only need help with letters A through D, help with as many as you can please. Also use excel formulas.
The focts for this problem are presented on the focts tab of this workbook. Instructions - Your solutions should be clearly labeled on the Solutions fab of thas wovkbook. For the first quarter of 2022 , do the following. (a) Prepare a siles budget. This is similior to illuttrotion 223 in your textbook (b) Prepare a production budget. This is similar to litustration 22.5 in your text book: (c) Prepare a dicect materiah budeet. (Round to nearest dollar) This is similar to Mustrotion 22.9 is your tentbook. (9) Prepare a direct labor budget. (For calculation, round to the nearest hour) Thir b imillor to illsitration 22 -12 in your teertbod: (e) Prepare a manulacturing overtead bustet. (Round litermediate amounts to the nearest dollac) The is similar to Molustrotion 22 - 12in your testbook: (f) Prepare a selline and adminhtrative budget. This in similor to illestrotion 22 - 11 is your textbook. (h) Prepare a canh budget. That is similor to illustrotion 2219 in your tertbook. You will aho need to prepare schedules to support your cakulation of amounts bortowed, intereit expense, and las repaymenta. these thould be weil abeled and formutted io thar i may follow your work Fule: Aoints are but for not followhy theie rules. - Uw tatets functionality to your benefit. Use formulas " Use proper formats for schediles, following the relerenced textbook examplei (ncludive taileis. - Une correct number formatifs, %, emeral and underscoring where appeopriste. - Double check your worvi verify vour formulas a nd logiel The company is preparing its budget for the coming year, 2022. The first step is to plan for the first quarter of that coming year. The follow information has been gathered from their managers. Grading guidelines are on the in 15 Finished Goods Inventory Planning 16 The company likes to keep 15% of the nert quarter's unit sales in finished goods ending inventory. Manufacturing Overhead Costs 42 Varioble costs per direct lobor hour Selling and Administrative Costs 63 Income Taxes 64 Acerued on Monthly Net income 65 Amounts Acerued Q42021 paid January 2022 \$5 rounded to nearest dollar 67 Cash and Financing Matters 68 Cash Balance, 12/31/2021 \begin{tabular}{l|l} 69 & 2022 Minimum Balance Required \\ 70 & \end{tabular} $135,000 1 Monthly Dividends 72 Outstanding Shares \begin{tabular}{|l|l} 73 & Une of Credit. \\ \hline 75 & \end{tabular} $1,90 per share 75. Limit 76 Borrowing increment Required 77 Annual interest Rate 78 Borrowings occur on the \begin{tabular}{ll} 79 Repaymentsoccur on the & First of Month \\ 80 & interest accrues on the loon bolancefrom the date ofborro of Month \\ \hline \end{tabular} 81 . Adstide 81 82 Additional Item \begin{tabular}{|l|l|l} \hline 83 & Fixed Asset Purchase & $40,000 \\ \hline 84 & Month & February \\ \hline \end{tabular} The focts for this probiem are presented on the facts tab of this werkbook. Instructions - Your soltions should be clearly labeled on the Solutions tab of this workboot. For the firt quarter of 2022, do the following. (a) Prepare a sales budget. This is smilar to inurtration 223 in your tertbook (0) Prepare a predstion budeet. This is umiler to rlesitretion 22.5 in your teatbool. Rule: Points are last for not followiog these nules. - Use Excefis functignality to your beneln. Une formulas - Use proper formats for schedulec, following the referenced textbook ewarmplei (inctutive ralei) " Lhe correct number formats is, X general and underscoring where appropriate. is, Deuble-checkyour workl verfy your formulas and legic! Wopne Corporation Master Eodget Project The company is preparing its budget for the coming year, 2022. The first step is to plan for the first quarter of that comir year. The followiog information has been gathered from theit managers. Grading guldelines are on the instructions tab. 67 Cash and Financing Matters 135,000 785,000 71 Monthly Dividends 72. Outstanding Shares $1.905,000 per share Une of Credit 75 Limit. 76 Borrowing increment Required 77. Annual Interest Rate 78 Borrowings occur on the 79 Repayments occur on the First of Month 80 Interest occrues on the loan balance from the date ofborrowing interest 81 . Interestaccrues on the loon balancejrom the date of borrowing. Interest accrued is paid first with each repayment. 82. Additional item 83 Fxed Asset Purchase 84 Month 5400,000
