70.2K

Verified Solution

Link Copied!

Hi! Please help with this budgeting excel.

I am stuck on box 6 and a few cells from 7&8. Thank you so much for the help.

thank you!

\begin{tabular}{|l|l|} \hline 57 & \\ \hline 59 & Insiructions \\ \hline 59 & \\ \hline 60 & Prepare a sales budget for March. \\ \hline 94 \end{tabular} Psopere a production budget for Marh, Propan a drect malerals purchases budget for March. Prepare a deect labor cost budget for March. Anwere: Pimbare a factory overitead cous budgen fot March. Prepare a seting and agministrative expences busget for Match. Prepare a buggoled nowme namenvent for Marth Gold Medal Athletic Co. Production Budget For the Month Ending March 31 Expected unts to be sold Dosimed inventory, March 31 Tolal units avalable Ettimated huentory, Marh 1 Total units to be piroduced Goid Medal Athletic Co. Direct Materials Purchases Budget Gold Medal Atriesic Co. Olrect Labor Cost Budget For the Month Ending March 31 5.185,792 Gold Medal Athletic Co. Factory Overhead Cost Budget For the Month Ending March 31 Indirect tactory wages Depreciation of plant and equipment Power and light Insurance and proporty tax Total \begin{tabular}{|rr|} \hline$ & 86,000 \\ \hline & 12,000 \\ \hline & 4,000 \\ \hline & 2,300 \\ \hline$ & 104,300 \\ \hline \end{tabular} Gold Medal Athletic Co. Cost of Goods Sold Budget For the Month Ending March 31 Finithed goods inventory, March 1 Woik in process, March 1 515,300 519,480 Orect materials: Direct materials hventory, March 1 Drect materals purchases Cost of direct materials avaloble for use Drect matorlals inventory, March 31 Cost of direct materals placed in production Diect labor Factory overtiead Total manufacturing costs Total work in process during period Work in process, March 1 Cost of goods manufactured Cost of finished goods avalable for sale Finkhed goods inventory, Much 31 Cost of goods sold Supporting caleulations: Finished goods inventory. March 1: \begin{tabular}{|rr|} \hline$ & 860 \\ \hline & 185,792 \\ \hline$ & 186,652 \\ \hline & (560) \\ \hline$ & 186,092 \\ \hline & 241,406 \\ \hline & 104,300 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 531,798 \\ \hline 5(516,998) \\ \hline(14,800) \\ \hline \end{tabular} Batting helmet Footbal heimet Total Finished goods inventory, March 31: Batting heimel Football heimet Total Diect malerias iaventory, March 1 Plastic Foum lning Total Drect malerats igventocy, March 31 Plastic Foam ining Total \begin{tabular}{|lr|} \hline & 532,298 \\ \hline$ & 551,778 \\ \hline & (18,410) \\ \hline$ & 533,368 \\ \hline \end{tabular} 7. Gold Medal Athletic Co. Selling and Administrative Expenses Budget For the Month Ending March 31 Selling expenses: \begin{tabular}{l} \hline Sales salaries expense \\ \hline Advertising expense \\ \hline Telephone expense - selling \\ \hline Travel Expense - seling \\ Total seling expenses \\ Adminisirative expenses: \\ \hline Office salaries expense \\ \hline Depr. expense - office equip. \\ \hline Telephone expense - administrative \\ \hline Orfice supples expense \\ \hline Miscollaneoue admin. expense \\ \hline \end{tabular} \begin{tabular}{|rr|} \hline 5 & 184,300 \\ \hline 87,200 \\ \hline & (5,800) \\ \hline(9,000) \end{tabular}. Total administrative expenses Total operating expenses \begin{tabular}{|r|} \hline$32,400 \\ \hline 3,800 \\ \hline 1,200 \\ \hline 1,100 \\ \hline 1,000 \\ \hline \end{tabular} \begin{tabular}{|lr} 5286,300 \\ \hline \end{tabular} \begin{tabular}{|lr|} \hline & 39,500 \\ \hline$325,800 \\ \hline \end{tabular} Gold Medal Athletic Co. Budgeted Income Statement For the Month Ending March 31 Revenue from sales Cost of goods sold Gross proft Operating expenses: \begin{tabular}{|lc|} \hline$ & 1,088,000 \\ \hline & (533,368) \\ \hline$ & 554,632 \\ \hline \end{tabular} Selling expenses Adminhtrative expenses Total operating oxpenses Operating income Other revenue and expense: \begin{tabular}{|rr|} \hline$286,300 \\ \hline & 39,500 \\ \hline \end{tabular} Interest revenue Interest expense Income before income tax Income tax expense Net noome \begin{tabular}{|ll|} \hline & (325,800) \\ \hline$ & 228,832 \\ \hline \end{tabular} with the ploned bubet, evile any assimption it you must dout list out your assomptonl. - the a sicembler lesthe atserbly deparinentfwages are affuted to meet now CVlitomia mirimum wage of 515/ hour. - The budpecid molone departatnt is tally aceurate so you do not need to changr

Answer & Explanation Solved by verified expert

See Answer