Question: Please answer this question, thank you so much Problem A Roswell Mfg. produced 80,000 units, 8,000 more than budgeted. Production data are as follows. Except

Please answer this question, thank you so much  Please answer this question, thank you so much Problem A Roswell
Mfg. produced 80,000 units, 8,000 more than budgeted. Production data are as

Problem A Roswell Mfg. produced 80,000 units, 8,000 more than budgeted. Production data are as follows. Except for physical units, all quantities are in dollars. Revenue & ActualSpending Flexible Activity Planning Results Variances Budget VariancesBudget 72,000 720,000 Physical Units Sales Variable Costs Contribution Margin Fixed Costs Operating Income 80,000 6,400 492,000 480,000- 30,000 150,000 138,000 1. In Excel, re-create & complete the schedule (determine values for all areas shaded in yellow). 2. Indicate whether variances are favorable (F) or unfavorable (U) where applicable. 3. Give a brief summary explanation of why the original target income was not attained. Problem B bbey Stores Limited, plans inventory levels (at cost) at the end of each month as follows: May: $271,000, June: $226,000, July: $209,000, and August: $241,000. Sales are expected to be Junde: $449,000, July: $359,000, August: $306,000. Cost of goods sold is 65% of sales. Purchases in April were $258,000 and in May they were $188,000. Payments for each month's purchases are made as follows: 15% during that month, 70% the next month, and the final 15% the next month. Prepare budget schedules for June, July, and August for purchases and for disbursements for purchases

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!