Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume? universal containers (uc) has over 10 million accounts with an average of 20 opportunities with each account. a sales executive at uc needs to generate a daily report for all opportunities in a specific opportunity stage.

a. a number of queries running at a time.
b. a number of joins used in report query.
c. a number of records returned by report query.
d. number of characters in report query.

Required information problem 15-1a production costs computed and recorded; reports prepared lo c2, p1, p2, p3, p4 [the following information applies to the questions displayed below. marcelino co.'s march 31 inventory of raw materials is $84,000. raw materials purchases in april are $540,000, and factory payroll cost in april is $364,000. overhead costs incurred in april are: indirect materials, $59,000; indirect labor, $26,000; factory rent, $38,000; factory utilities, $19,000; and factory equipment depreciation, $58,000. the predetermined overhead rate is 50% of direct labor cost. job 306 is sold for $670,000 cash in april. costs of the three jobs worked on in april follow. job 306 job 307 job 308 balances on march 31 direct materials $30,000 $36,000 direct labor 25,000 14,000 applied overhead 12,500 7,000 costs during april direct materials 133,000 210,000 $100,000 direct labor 105,000 150,000 101,000 applied overhead ? ? ? status on april 30 finished (sold) finished in process (unsold) required: 1. determine the total of each production cost incurred for april (direct labor, direct materials, and applied overhead), and the total cost assigned to each job (including the balances from march 31). a-materials purchases (on credit). b-direct materials used in production. c-direct labor paid and assigned to work in process inventory. d-indirect labor paid and assigned to factory overhead. e-overhead costs applied to work in process inventory. f-actual overhead costs incurred, including indirect materials. (factory rent and utilities are paid in cash.) g-transfer of jobs 306 and 307 to finished goods inventory. h-cost of goods sold for job 306. i-revenue from the sale of job 306. j-assignment of any underapplied or overapplied overhead to the cost of goods sold account. (the amount is not material.) 2. prepare journal entries for the month of april to record the above transactions. 3. prepare a schedule of cost of goods manufactured. 4.1 compute gross profit for april. 4.2 show how to present the inventories on the april 30 balance sheet.

Hank itzek manufactures and sells homemade wine, and he wants to develop a standard cost per gallon. the following are required for production of a 70-gallon batch. 2,700 ounces of grape concentrate at $0.04 per ounce 77 pounds of granulated sugar at $0.43 per pound 133 lemons at $0.79 each 350 yeast tablets at $0.24 each 350 nutrient tablets at $0.14 each 2,500 ounces of water at $0.001 per ounce hank estimates that 4% of the grape concentrate is wasted, 9% of the sugar is lost, and 32% of the lemons cannot be used. compute the standard cost of the ingredients for one gallon of wine. (round intermediate calculations and final answer to 2 decimal places, e.g.

The chromosome manufacturing company produces two products, x and y. the company president, jean mutation, is concerned about the fierce competition in the market for product x. she notes that competitors are selling x for a price well below chromosome's price of $13.50. at the same time, she notes that competitors are pricing product y almost twice as high as chromosome's price of $12.50.ms. mutation has obtained the following data for a recent time period: product x product y number of units 11,000 3,000 direct materials cost per unit $3.23 $3.09 direct labor cost per unit $2.22 $2.10 direct labor hours 10,000 3,500 machine hours 2,100 1,800 inspection hours 80 100 purchase orders 10 30ms. mutation has learned that overhead costs are assigned to products on the basis of direct labor hours. the overhead costs for this time period consisted of the following items: overhead cost item amount inspection costs $16,200 purchasing costs 8,000 machine costs 49,000 total $73,200using direct labor hours to allocate overhead costs determine the gross margin per unit for product x. choose the best answer from the list below.a. $1.93b. $3.12c. $7.38d. $2.43e. $1.73using activity-based costing for overhead allocation, determine the gross margin per unit for product y. choose best answer from list below.a. $10.07b. ($2.27)c. ($5.23)d. ($7.02)e. $7.02