Compute the Overhead Budget & Selling and Administrative Budget.

Budget Excel Project Bloomfield Co. iS an ice OCSh rornm am-I areas ot to 25,000 wits in 1 cf 2024, an urets ere to end 012m] 2025. Tng 2023 quarter sales 24.000 B%mflekd ot qrters in emding sales to rctail stores aro cn account, witn coleaions o' rnadc in tng qE1ter of in the I. 2023 is 372.000 Materials matenals cost S3 pournl TS pounds c.' materiat5 are to each 6% ot Its emdirg Raw on D 31.2023 2,2GC for in ot vd in attov is 15 minut unit et a rete of S 1 Manufacturina Manufacturing Overhead Vanable overhead costs are based on labor hours, listed below: Indirect materials 50e per labor hour Sellinq a AdministraEv Variable adrrunistrative are s.&s Shppng expense per sae urit Packaging expense S SO per sales .nt Fixed CCrStS are Indirect bor Utilities Maintenance 75e per labor hour 65' per labor hour 35e per labor hour Advert ng Off ce Salaries nepreaation Offer I nforrnation a morth S/ 00 a rnmth Sd COJ a Foxed overhead costs are budgeted torthe month, listed below: Salaries Depreciation Property taxes Insurance $3,000 per month Sl 1 ,OOO per month S4,dOO per month $ 675 per month S 500 per month The Cash baance at the end 2023, is 750, ard Blcornfieid Wouk} ike to cash At S200,OdO At ot A1 Oirect Labor, Mardacnnng C&ef-ead and Pdmimstrative costs are paid in incurred Bloomhekd an open ot credit 'mth the and can in am don't the minimum Cash Borrcmed funds accrue irteest for rarter and are paid in first quarter Cash IS "'h Bloomfiek_d collects i'terest S3,COO torn a note receivable each auafler Bloomfiekl plats to purchase a S50.OOO in cash in 3 pays an estimated tax at $5,000 each Compute the Overhead Budget & Selling and Administrative Budget.