Calculate the Unit Production Cost

18: Calculate the Unit Product Cost using the table below: 20 Total ABC Company For the Year Ended December 31, 2020 Item Quantity Cost Production cost per unit: Direct materials pounds per pound Direct labor hours per hour Manufacturing overhead hours per hour Unit product cost K14 C D F G 1 ABC Company 2 Assumptions 4 Sales: 5 Estimated Unit Sales: Q1 15,000 2020 Q2 40,000 Q3 18,000 Q4 24,000 2021 Q1 Q2 12,000 38,000 7 Selling Price per Unit 30.00 9 Expected Cash Collections: All Sales are on Account Collections in Quarter of Sale (12 Collections in Quarter Following Sale 70% 30% 14 Production Budget: 15 Desired Ending Inventory 15% of following quarter's budgeted sales (units) 16 17 Direct Materials Budget: 18 Raw materials required to produce one unit Desired raw materials on hand 20 Raw material costs 3 pounds 10% of following month's production needs 3.00 per pound $ 22 Expected Cash Payments 23 Payments in the Month of Purchase 24 Payments in the Month Following Purchase 25 75% 25% K14 $ 0.25 hours 20.00 26 Direct Labor Budget: 27 Direct Labor Required per Unit 28 Hourly Pay Rate 29 30 Manufacturing OH Budget: 31 Variable Manufacturing OH Rate 32 Fixed Manufacturing OH 33 Depreciation EA CA EA 3.00 per DLH. $ 99,911.25 per quarter $ 10,000 per quarter 34 36 35 Selling & Administrative Expense Budget Variable S&A Expense Rate Fixed S&A Expenses Depreciation GA GA GA 1.00 per unit sold 85,000 per quarter 5,000 per quarter $ 30.000 50,000 40 Cash Budget: Minimum cash balance Cash dividend each quarter Line of Credit: Quarterly Interest Rate Maximum Balance Borrowings occur on the first day of the quarter. Repayments occur on the last day of the quarter. 2.5% 150,000 45 $