Think about data collected and used by Netflix. a. Identify three tables that would contain customer or subscription data.

1. Cash receipt tableunchecked
2. Sales tableunanswered
3. Employee codeunanswered
4. Customer tableunanswered
5. Payment detailunanswered

b. For each table given below, list five attributes (you may include primary and foreign keys as well as non-key attributes).

Customer table:

1. Customer nameunanswered
2. Customer zipunanswered
3. Salary basicunanswered
4. Customer#unanswered
5. Customer phone#unanswered
6. Customer email addressunanswered

Sales table:

1. Item#unanswered
2. Customer#unanswered
3. Purchaseunanswered
4. Sales dateunanswered
5. Sales#unanswered
6. Employee#unanswered

Cash receipt:

1. Cash receipt dateunanswered
2. Cash receipt amountunanswered
3. Account detailunanswered
4. Cash receipt#unanswered
5. Customer#unanswered
6. Sales#

“wonderful! not only did our salespeople do a good job in meeting the sales budget this year, but our production people did a good job in controlling costs as well,” said kim clark, president of martell company. “our $11,150 overall manufacturing cost variance is only 3% of the $1,536,000 standard cost of products made during the year. that’s well within the 3% parameter set by management for acceptable variances. it looks like everyone will be in line for a bonus this year.” the company produces and sells a single product. the standard cost card for the product follows: standard cost card—per unit direct materials, 4.00 feet at $4.00 per foot $ 16.00 direct labor, 1.1 direct labor-hours at $13 per direct labor-hour 14.30 variable overhead, 1.1 direct labor-hours at $2.40 per direct labor-hour 2.64 fixed overhead, 1.1 direct labor-hours at $6.50 per direct labor-hour 7.15 standard cost per unit $ 40.09the following additional information is available for the year just completed: a. the company manufactured 20,000 units of product during the year. b. a total of 77,000 feet of material was purchased during the year at a cost of $4.25 per foot. all of this material was used to manufacture the 20,000 units. there were no beginning or ending inventories for the year. c. the company worked 24,000 direct labor-hours during the year at a direct labor cost of $12.50 per hour. d. overhead is applied to products on the basis of standard direct labor-hours. data relating to manufacturing overhead costs follow: denominator activity level (direct labor-hours) 19,000 budgeted fixed overhead costs $ 123,500 actual variable overhead costs incurred $ 64,800 actual fixed overhead costs incurred $ 120,900required: 1. compute the materials price and quantity variances for the year. (round standard price and actual price to 2 decimal places. indicate the effect of each variance by selecting "f" for favorable, "u" for unfavorable, and "none" for no effect (i. e., zero 2. compute the labor rate and efficiency variances for the year. (round standard rate and actual rate to 2 decimal places. indicate the effect of each variance by selecting "f" for favorable, "u" for unfavorable, and "none" for no effect (i. e., zero 3. for manufacturing overhead compute: a. the variable overhead rate and efficiency variances for the year. (round standard rate and actual rate to 2 decimal places. indicate the effect of each variance by selecting "f" for favorable, "u" for unfavorable, and "none" for no effect (i. e., zero b. the fixed overhead budget and volume variances for the year. (indicate the effect of each variance by selecting "f" for favorable, "u" for unfavorable, and "none" for no effect (i. e., zero

Suppose that a monopolistically competitive restaurant is currently serving 260 meals per day (the output where mr

Down under products, ltd., of australia has budgeted sales of its popular boomerang for the next four months as follows: unit salesapril 74,000may 85,000june 114,000july 92,000the company is now in the process of preparing a production budget for the second quarter. past experience has shown that end-of-month inventory levels must equal 10% of the following month’s unit sales. the inventory at the end of march was 7,400 units. required: prepare a production budget by month and in total, for the second quarter.