please show working

Croak Manufacturing preparing to master buget for their care 1 Click the bon to view the data) Click the len to view period Sales for the five months of the upcoming year are budgeted to be as to Cureless 20% and Alo ne mong the c handing intory of the goods should be the following 8 Cer more Ofsach 4900 e has w o n the month of purchase while the remaindera p rin the month The Ending ordrec h od 's produtos ng conversion cows are $4.000 for tactory rent, $2,600 for other feed mandating en d 120 acting the depreciated w ith in which 200 20 Mereymo o un for yet Com 223 # 22.000 e 6.200 will be purchased in the upcoming in January. Ciek Mancungwa whereby's expenditure will be 12.000 and Maris pendir ist11 e p 10 th more in which they are more nge penge of 1.400 per mon Al operating w i 20 0 g spory ending chance in each month must be in order with a bark The com can borrow in increments of $1.000 at the beginning of each months to outstanding loan ce 100.000 The w ensen is the warm e Man e ces and on the company was the the end o n the bouge quat d 2 Enter any under the Port Dore Check And Cicek Manufacturing Cash Collection Budget January February $ 19,920 $ 22,080 $ 57,600 7 9,680 77,520 $ 101,760 $ Cash sales March Quarter 22,560 $ 64,560 88,320 225,600 110,880 $ 290,160 Credits sales Total cash collections Requirement 2. Prepare a production budget. (Hint: Unit sales - Sales in dollars / Selling price per unit.) Unit sales Cicek Manufacturing Production Budget January February 8,300 9,200 2,300 2,350 10,600 11,550 (2,075) (2,300) 8,5259 Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce March 9,400 2,425 11,825 (2,350) 9.475' Quarter 26,900 2,425 29,325 (2,075) 9,250" 27,250 Direct Materials Budget January February March Quarter Units to be produced 8,5259 ,250 9,475 27,250 x kg of DM needed per unit Quantity (kg) needed for production 25,575 27,750 28,425 81,750 Plus: Desired ending inventory of DM 5,550 5,685 5,700 5,700 Total quantity (kg) needed 31,125 33,435 34,125 87,450 Less: Beginning inventory of DM (5,115) (5,550) (5,685) (5,115) Quantity (kg) to purchase 26,010 27,885 28,440 82,335 x Cost per kg 2.00 $ 2.00 $ 2.00 $ 2.00 52,020 $ Total cost of DM purchases 55,770 $ 56,880 $ 164,670 Requirement 4. Prepare a cash payments budget for the direct material purchases from Requirement 3. (Lear Cicek Manufacturing Cash Payments for Direct Material Purchases Budget January February March Quarter December purchases (from Accounts Payable) $ 42,400.00 $ 42,400.00 January purchases $ 10,404.00 $ 41,616.00 $ 52,020.00 February purchases $ 11,154.00 $ 44,616.00 $ 55,770.00 March nurchases $ 11,376.00 $ 11,376.00 Requirements $ 11,376.00 $ 11,376.00 March purchases $ 52,804.00 $ 52,770.00 $ 55,992.00 $ 161,566.00 Total cash payments for DM purchases Requirement 5. Prepare a cash payments budget for conversion costs. (Round your answers to the nearest whole dollar. Cicek Manufacturing Cash Payments for Conversion Costs Budget January February March Quarter Variable conversion costs 10,230 $ 11,100 $ 11,370 $ 32,700 Rent (fixed) 4,000 4,000 4,000 12,000 2,900 Other fixed MOH 2,900 2,900 8,700 17,130 $ 18,000 $ 18,270 $ 53,400 Total payments for conversion costs Requirement 6. Prepare a cash payments budget for operating expenses. (Round your answers to the nearest whole dollar Cicek Manufacturing Cash Payments for Operating Expenses Budget January February March Quarter Variable operating expenses $ 9,130 $ 10,120 $ 10,340 $ 29,590 Fixed operating expenses 1,400 1,400 1,400 4,200 10,530's Total payments for operating expenses 11,520's 11,740's 33,790 Requirements combined casn Duager January Cash balance, beginning Add cash collections Total cash available Less cash payments: Direct material purchases Conversion costs Operating expenses Equipment purchases Tax payment Total cash payments Excess (deficiency) of cash Financing: Borrowings Repayments Interest payments Total financing Cash balance, ending