Completely lost as to how to go about C-9, problem 39 in Managerial Accounting 10th edition. We covered the master budget briefly in class, but I don't understand how to start this particular question. I've attached pictures here. Any and all help would be appreciated.

Edgeworth Box 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 Problem 9-39 Preparation of Master Budget Problem 9-39 Excel template Type of Box Direct material required par 100 boes: LO 9-3, 9-4, 9-5, 9-6) 1. Total sales revenue $1,650,000 4. Total direct-labor cost: $66,825 Corrugating medium 15 per pound) Paperboard 30 per pound) 20 pounds 30 pounds 25 hour 30 pounds 70 pounds 50 hour Direct labor required pr 100 boxas ($18.00 per hour.. The unit production costs for each product are expected to be the same this year and next year The following production-overhead costs are anticipated for the next year. The predetermined overhead rate is based on a production volume of 495,000 units for each type of box. Production overhead is applied on the basis of direct-labor hours Indirect materia Indirect labor Utlities Proparty taxes Insurance Dapreciation Total 15,750 75,000 37,500 27,000 24,000 43,500 $222,750 The following selling and administrative expenses are anticipated for the next year. Salaries and fringe benefits of sales personnal Advertising Management salaries and fringe benefits Clerical wagas and frings banefits Miscellaneous administrative expensas Total $112500 22,500 135,000 39,000 6,000 315,000