Your first assignment is to prepare a master budget for the next fiscal year, starting April 1, 2021. Your co-workers have left a pile of files on your desk including the past sale records, product information, manufacture schedule and supplier pricing list. Now, you realized that you should have pay more attention during the lecture. The marketing department has forwarded you with forecasted sales volumes for the next 12 months see below: Date Units Date Units APR, 2021 500,000 OCT, 2021 500,000 MAY, 2021 520,000 NOV, 2021 515,000 JUNE, 2021 515,000 DEC, 2022 530,000 JULY, 2021 520,000 JAN, 2022 520,000 AUG, 2021 500,000 FEB, 2022 530,000 SEP, 2021 520,000 MAR, 2022 540,000 *APR, 2022 sales volume is expected to be 530,000 units To meet its monthly sales, the company has mandated that monthly ending finished goods inventories are supposed to be equal to 25% of the next months sales in units. the company currently does its own assembly production in house. Each pizza consists of 2 pounds of flour and the cost of each pound is $0.10. Each unit needs 0.10 labour hour from raw material preparation to finished package. The hourly pay rate to the assembling workers is $12 per hour. The production manager also required desired direct material ending inventory, which is enough for 30% of the next month production. The production units in April 2022 are estimated to be 780,000 units. The companys are sold to retailers for $3 each.