I am having trouble solving for the cost of goods sold budget, cash receipts budget, cash budget. Please help!
S For the Year Ended 12/11/2020 Financial Data and Assumptions lal al Quarter Projected Sales for 2019 (Units) Proiected Sales for 2020 ) Projected sales for 2001 el PURCLASING DATA 01 02 700,000 550,000 88 Prejected Cash Payments for 2020 03 650.000 04 75.000 8 8 88 A ENT 38161 TIRI 88 TL LIEN Estimated Sales PricePerUnit (2019) Estimated Sales Price Per Unt (2020) Estimated Sales PricePerUnit 12021) 15 88 TL TI PRODUCTION DATA Finished Goods Date Finished Goods ending inventory estimated to be Beginning inventory Prior to FINANCIAL DATA Cash Receipts Date Percentage of total sales that are cash sales Percentage of total sales are credit sal Percentage of credit sales paid in quarter of sale Percentage of credit sales paid in following quarter T Direct Material Dete OM cost per unit DM ending inventory estimated to be 33 & Cash Budget Dato Minimum required cash balance Money is borrowed for the act amount needed 25,000 Direct Labor Dato OL hours per unit DL rate per hour Overtime is paid out at time and 1/2 interest is charged at 1.50 Manufacturing Overhead Date Variable OH cost per unit Fixed OH costs Depreciation Utilites, insurance property tam OH is allocated based on OL hours 10.000 25.000 Cost of Good Date PY total manufacturing cost Beginning inventory Current Year Unit Cost Information Direct Materials Direct Labor Labor hours required per unit Predetermined OH location rate 3.00 18.00 1.50 25.00 Manufacturing Cost per Unit For the Year Ended 12/31/2020 DM cost per unit DL cost per unit Predetermined OH allocation rate per unit Total Manufacturing Cost per unit 8.00 18.00 25.00 51.00 Cost of Goods Sold (COGS) Budget For the Year Ended 12/31/2020 Q1 Q2 Q3 25,000 26,000 27,000 Q4 30,000 Total 108,000 Total units to sell Beginning inventory units Units produced and sold 25,0001126,000 30,000 108,000 Beginning inventory Inventory produced and sold Budgeted COGS COGS to Income Statement Q2 02 03 04 Cash Receipts Budget For the Year Ended 12/31/2020 Q4 Q1 Total budgeted sales Cash receipts Q1 Cash sales Credit sales - collected in current quarter Credit sales - collected in following quarter Total cash receipts Q2 Q3 Q4 Total Cash Receipts Year End Accounts Receivable Balance S For the Year Ended 12/11/2020 Financial Data and Assumptions lal al Quarter Projected Sales for 2019 (Units) Proiected Sales for 2020 ) Projected sales for 2001 el PURCLASING DATA 01 02 700,000 550,000 88 Prejected Cash Payments for 2020 03 650.000 04 75.000 8 8 88 A ENT 38161 TIRI 88 TL LIEN Estimated Sales PricePerUnit (2019) Estimated Sales Price Per Unt (2020) Estimated Sales PricePerUnit 12021) 15 88 TL TI PRODUCTION DATA Finished Goods Date Finished Goods ending inventory estimated to be Beginning inventory Prior to FINANCIAL DATA Cash Receipts Date Percentage of total sales that are cash sales Percentage of total sales are credit sal Percentage of credit sales paid in quarter of sale Percentage of credit sales paid in following quarter T Direct Material Dete OM cost per unit DM ending inventory estimated to be 33 & Cash Budget Dato Minimum required cash balance Money is borrowed for the act amount needed 25,000 Direct Labor Dato OL hours per unit DL rate per hour Overtime is paid out at time and 1/2 interest is charged at 1.50 Manufacturing Overhead Date Variable OH cost per unit Fixed OH costs Depreciation Utilites, insurance property tam OH is allocated based on OL hours 10.000 25.000 Cost of Good Date PY total manufacturing cost Beginning inventory Current Year Unit Cost Information Direct Materials Direct Labor Labor hours required per unit Predetermined OH location rate 3.00 18.00 1.50 25.00 Manufacturing Cost per Unit For the Year Ended 12/31/2020 DM cost per unit DL cost per unit Predetermined OH allocation rate per unit Total Manufacturing Cost per unit 8.00 18.00 25.00 51.00 Cost of Goods Sold (COGS) Budget For the Year Ended 12/31/2020 Q1 Q2 Q3 25,000 26,000 27,000 Q4 30,000 Total 108,000 Total units to sell Beginning inventory units Units produced and sold 25,0001126,000 30,000 108,000 Beginning inventory Inventory produced and sold Budgeted COGS COGS to Income Statement Q2 02 03 04 Cash Receipts Budget For the Year Ended 12/31/2020 Q4 Q1 Total budgeted sales Cash receipts Q1 Cash sales Credit sales - collected in current quarter Credit sales - collected in following quarter Total cash receipts Q2 Q3 Q4 Total Cash Receipts Year End Accounts Receivable Balance
