please fill out OH / S&A EXP budget spreadsheet please

INPUT SECTION SALES Wheels & Widgets Inc. Budget Project Fall 2023 4th 1st 2nd 3rd 4th Quarter Quarter Quarter Quarter Quarter 2023 2024 2024 2024 2024 Budgeted Sales in units 41,000 49,100 34,500 31,000 43,000 1 Budgeted Selling Price $ 530 per production unit (Finished Goods) 2 3 4 RECEIVABLES 5 Receivables Collection Schedule 6 7 8 9 20 21 INVENTORY COSTS Policy 81.50% quarter of sale 16.00% quarter following sale 2.50% uncollectible 100.00% Entire projected uncollectible receivables are written off each quarter 22 Direct Labor 23 $ 24 25 Raw Materials 26 27 28 Variable Overhead $ $ 10.50 per Direct Labor Hour 4.5 hours 18.00 per direct labor hour 3 pounds per finished goods unit 85.00 per pound 29 30 Fixed Overhead 31 Depreciation $ 196,640 per quarter 32 Other Fixed Overhead 5 950,000 per quarter 33 34 Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET