This is due in 20 min. I need help.

January 1,200 February 1,000 March Quartet 1 1 1,600 3,800 300 480 420 420 A) Production Budget Budgeted Unit Sales Add:Desired Ending finished inventory Next period budgeted sales units Ratio of inventory to future sales Desired ending inventory units Total Required Units Less: Beginning finished inventory Units to produce 1,000 30% 20x) ) 1.500 240 1,160 1,600 30% 4C 1,180 300 1,180 1,400 30% 420 2,020 490 1,540 1,400 30% 420 1,220 340 3,880 3. RRO (B) Direct Materials Budget Units to produce Material required per unit Total Raw Materials Inv. Add desired ending materials puunds Total Oz. Need less Beg. Inventory Materials to purchase lounces) January 1,160 18 20,880 February 1,180 18 21,240 8,316 29,556 6,372 23,184 March loi Q1 1,540 18 27,720 8208 35,928 8,716 27,612 18 69,840 820H 78,018 1,200 69,840 27,252 6000 21,252 Materials cost per Ounce Cost of direct material purchases 5 S 0.315 6,611 S 0.31S 7,215 $ 0.31 $ 8,629 $ 0.31 21,825 C). Direct Labor Budget Units to produce Labor hours required per unit Direct labor hours needed January 1,160 0.125 145 February 1,180 0.125 118 March 1,540 0.125 193 3,880 0.125 185 Direct labor cost per hour Cost of direct labor S S 20 S 2,900 $ 20 2,950's S 3,850 $ 20 9,700 (D) Factory Overhead Budget Total Direct lebar Ilnur Required V Overhead per hr V Overhead V ADD fixed overhead Budgeted total factory overhead January February March 101 Q1 145 1431 193 29.85 29.85 29.85 4,328 4,403 5,746 5,520 5,520 5,520 S 9,818 S 9,923 $ 11,266 $ 485 29.85 14,477 5,520 19,997 These are rounded I guess? The Sweetwater Candy Company is preparing its budget for next year and has asked you to prepare a cash budget for the first quarter (January March) of next year. . Selling price for a single box of chocolates: $25 per unit % collected November December January February March Budgeted total sales are: 40% cash sales 60% credit sales Cash Receipts from sales Sales in Cash receipts from Cash Sales Collections of month prior Collections of 2 months prior Total cash receipts % collected December January February March Credit sales are collected in cash as follows: 75% collected in the month following the sale % 25% collected in the 2nd month following the sale At December 31, the balance in Accounts Receivable is $24,750, which represents the uncollected portions of the November and December sales. November total sales 1000 units December total sales 1400 units Budgeted sales for the next four months follow: January February March April Sales in units 1,200 1.000 1,600 1,400 Raw materials (chocolate) purchases are paid in cash as follows: : 40% paid in the month of purchase 60% paid in the month following purchase Cash Payments for purchases DM purchases Cash payments for: Current period purchases Prior periud purchases Total cash payments January February March At December 21, the balance of Accounts Payable is $4,977, which represents the unpaid portion of December's raw materials (chocolate) purchases. The actual cost of raw materials in December was $8,295. TIINI: You must pull the raw materials costs from the Pruduttion Bucgel. Direct labor and variable overhead costs are paid in the month applied. . Fixed overhead includes $2,520 per month of depreciation on factory equipment The remaining fixed overhead costs are paid evenly throughout the year. HINT: You must oull the direct labor and overhead costs from the Production Budget. The following coperating experies are paid in the month incurred: Shipping is 2% of sales. Sales commissions are 10% of sales. Office salaries are $3,000 per month. Office rent is $1,200 per month. In January, management plans to pay $10,000 of cash dividends to its shareholders. Cash Budget Beginning cash balance + Cash is fur sales Sale of equipment Total Cash Available Cash Payments for: Direct materials Direct lat Variable OH Fixed OH Shipping Expense Sales Commissions Office Sularies Office Rent Cash Dividends Interest on Loan Total Cash Payments Preliminary cash balance + Amur brows - Amount of loan repaid Ending cash balance Ending Loan balance Interest rate per month . In March, management expects to sell equipment that originally cost $12,000 at again of $1,500 Accumulated depreciation on this equipment at the time of sale will be $7,000. The equipment will be sold for cash. A minimum cash balance of $10,000 is required. - The cash balance at December 31 is $10,200 Loans are obtained at the end of a month in which a cash shortage occurs. Interest is 12% annually (or 1% per month), based on the loan balance at the beginning of the month, and must be It an excess of cash exists, loan repayments are made at the end of the month. At December 31, the loan balance is $0 Required: (A.) Prepare the company's cash budget for each of the months nf January, February, and March that includes information on the loan balance. (B.) Prepare supplemetary schedules tor cash receipts from customers and cash disbursements for raw materials January 1,200 February 1,000 March Quartet 1 1 1,600 3,800 300 480 420 420 A) Production Budget Budgeted Unit Sales Add:Desired Ending finished inventory Next period budgeted sales units Ratio of inventory to future sales Desired ending inventory units Total Required Units Less: Beginning finished inventory Units to produce 1,000 30% 20x) ) 1.500 240 1,160 1,600 30% 4C 1,180 300 1,180 1,400 30% 420 2,020 490 1,540 1,400 30% 420 1,220 340 3,880 3. RRO (B) Direct Materials Budget Units to produce Material required per unit Total Raw Materials Inv. Add desired ending materials puunds Total Oz. Need less Beg. Inventory Materials to purchase lounces) January 1,160 18 20,880 February 1,180 18 21,240 8,316 29,556 6,372 23,184 March loi Q1 1,540 18 27,720 8208 35,928 8,716 27,612 18 69,840 820H 78,018 1,200 69,840 27,252 6000 21,252 Materials cost per Ounce Cost of direct material purchases 5 S 0.315 6,611 S 0.31S 7,215 $ 0.31 $ 8,629 $ 0.31 21,825 C). Direct Labor Budget Units to produce Labor hours required per unit Direct labor hours needed January 1,160 0.125 145 February 1,180 0.125 118 March 1,540 0.125 193 3,880 0.125 185 Direct labor cost per hour Cost of direct labor S S 20 S 2,900 $ 20 2,950's S 3,850 $ 20 9,700 (D) Factory Overhead Budget Total Direct lebar Ilnur Required V Overhead per hr V Overhead V ADD fixed overhead Budgeted total factory overhead January February March 101 Q1 145 1431 193 29.85 29.85 29.85 4,328 4,403 5,746 5,520 5,520 5,520 S 9,818 S 9,923 $ 11,266 $ 485 29.85 14,477 5,520 19,997 These are rounded I guess? The Sweetwater Candy Company is preparing its budget for next year and has asked you to prepare a cash budget for the first quarter (January March) of next year. . Selling price for a single box of chocolates: $25 per unit % collected November December January February March Budgeted total sales are: 40% cash sales 60% credit sales Cash Receipts from sales Sales in Cash receipts from Cash Sales Collections of month prior Collections of 2 months prior Total cash receipts % collected December January February March Credit sales are collected in cash as follows: 75% collected in the month following the sale % 25% collected in the 2nd month following the sale At December 31, the balance in Accounts Receivable is $24,750, which represents the uncollected portions of the November and December sales. November total sales 1000 units December total sales 1400 units Budgeted sales for the next four months follow: January February March April Sales in units 1,200 1.000 1,600 1,400 Raw materials (chocolate) purchases are paid in cash as follows: : 40% paid in the month of purchase 60% paid in the month following purchase Cash Payments for purchases DM purchases Cash payments for: Current period purchases Prior periud purchases Total cash payments January February March At December 21, the balance of Accounts Payable is $4,977, which represents the unpaid portion of December's raw materials (chocolate) purchases. The actual cost of raw materials in December was $8,295. TIINI: You must pull the raw materials costs from the Pruduttion Bucgel. Direct labor and variable overhead costs are paid in the month applied. . Fixed overhead includes $2,520 per month of depreciation on factory equipment The remaining fixed overhead costs are paid evenly throughout the year. HINT: You must oull the direct labor and overhead costs from the Production Budget. The following coperating experies are paid in the month incurred: Shipping is 2% of sales. Sales commissions are 10% of sales. Office salaries are $3,000 per month. Office rent is $1,200 per month. In January, management plans to pay $10,000 of cash dividends to its shareholders. Cash Budget Beginning cash balance + Cash is fur sales Sale of equipment Total Cash Available Cash Payments for: Direct materials Direct lat Variable OH Fixed OH Shipping Expense Sales Commissions Office Sularies Office Rent Cash Dividends Interest on Loan Total Cash Payments Preliminary cash balance + Amur brows - Amount of loan repaid Ending cash balance Ending Loan balance Interest rate per month . In March, management expects to sell equipment that originally cost $12,000 at again of $1,500 Accumulated depreciation on this equipment at the time of sale will be $7,000. The equipment will be sold for cash. A minimum cash balance of $10,000 is required. - The cash balance at December 31 is $10,200 Loans are obtained at the end of a month in which a cash shortage occurs. Interest is 12% annually (or 1% per month), based on the loan balance at the beginning of the month, and must be It an excess of cash exists, loan repayments are made at the end of the month. At December 31, the loan balance is $0 Required: (A.) Prepare the company's cash budget for each of the months nf January, February, and March that includes information on the loan balance. (B.) Prepare supplemetary schedules tor cash receipts from customers and cash disbursements for raw materials