i need solution for given attachment in excel with relevant formulas

Revised Problem 9-43 Freshpak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C Direct material required per 100 boxes: Paperboard ($.30 per pound) 20 pounds Corrugating medium ($.20 per pound) 20 pounds Direct labor required per 100 boxes ($10.00 per hour): .30 hour The following manufacturing-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 485,000 units for each type of box. Manufacturing overhead is applied on the basis of direct-labor hours. $ Indirect material Indirect labor Utilities Property Taxes Insurance Depreciation Total 4,500 47,000 15,000 12,000 16,175 29,000 123,675 The following selling and administrative are anticipated for the next year. 75,000 15,000 90,000 26,000 4,000 210,000 Salaries and fringe benefits of sales personnel Advertising Management salaries and fringe benefits Clerical wages and fringe benefits Miscellaneous administrative expenses Total The sales forecast for the next year is as follows: Sales Volume Box type C 495,000 boxes Box type P 495,000 boxes Sales Price $85.00 per hundred boxes 110.00 per hundred boxes The following inventory information is available for the next year. The unit production costs for each product are expected to be the same this year and next year. Finished goods: Box type C Box type P Raw material: Paperboard Corrugating medium Expected Inventory January 1 Desired Ending Inventory December 31 16,000 boxes 18,000 boxes 6,000 boxes 8,000 boxes 12,000 pounds 6,000 pounds 10,000 pounds 9,000 pounds Required: Prepare a master budget for Freshpak Corporation for the next year. Assume an income tax rate of 40 percent. Include the following schedules. 1. Sales budget 2. Production budget 3. Direct-material budget 4. Direct-labor budget 5. Manufacturing-overhead budget 6. Selling and administrative expense budget 7. Budgeted income statement (Hint: To determine cost of goods sold, first compute the manufacturing cost per unit for each type of box. Include applied manufacturing overhead in the cost). ping canned food, fruit e P) have the following Type of Box P 60 pounds 30 pounds .55 hour he predetermined overhead ction costs for Revised Exercise 11-26 The following data are the actual results for Marvelous Marshmallow Company for October. Actual output Actual variable overhead Actual fixed overhead Actual machine time 9,000 cases 420,000 122,000 40,500 machine hours Standard cost and budget information for Marvelous Marshmallow Company follows: Standard variable-overhead rate Standard quantity of machine Budgeted fixed overhead Budgeted output $8.50 per machine hour 3 hours per case of marshmallows $130,000 per month 10,833 cases per month Required: 1. Use any of the methods explained in the chapter to compute the following variances. Indicate whether each variance is favorable or unfavorable, where appropriate. a. Variable-overhead spending variance. b. Variable-overhead efficiency variance. c. Fixed-overhead budget variance. d. Fixed-overhead volume variance. 2. Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: actual output 9,100 cases, and actual variable overhead was $395,000. nces. Indicate equirement. Show