plz prepare master budget using figuers mentioned in Q on second page

to share xl sheet plz send me your email

Managerial Accounting - Assignment 3 Prepare the master budgets for a manfacturing company for the year 2022 using the following data Period Fourth quarter 2021 5000 80 First quarter 2022 6000 90 Second quarter 2022 7000 90 Third quarter 2022 8000 95 Fourth quarter 2022 9000 First quarter 2023 10,000 100 95 Sales quantity Sales price per unit (SR) The ending production inventory 20% of the sales quantity for the next quarter The ending inventory of material (10% of the material quantity for the next quarter) End cash balance (SR) 2000 kilogram 10,000 Material per unit 3 kilogram Material price: SR 4 direct labor hours to produce one unit = 2 hours The direct labor rate per hour is SRS The variable overhead rate per Direct Labor hour is SR4 The quarterly fixed overhead cost is estimated at SR12,000 (includes SR2000 depreciation) The cost of package is SR2 per unit and the sales commission is 5% of the sales revenue. The quarterly fixed marketing cost is SR20,000 (includes SR.5000 depreciation) The quarterly administrative expense is SR30,000 (includes 5000 depreciation) The cash sales is 40% of sales and the credit sales is 60% to collected next quarter 70% of purchases is cash and 30% is on credit to collected next quarter the cost of purchases for the fourth quarter 2021 was SA60,000) The company intend to has minimum cash balance at the end of each quarter SA10,000, in case of the end cash balance is less than SA 10,000, the company will borrow by annual interest rate 12%, and repay if there is sufficient cash. Enter text or formula here