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
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
Get step-by-step solutions from verified subject matter experts
