Question: will give a good review for the quick answer! Just need help with 10 A & B on the bottom. Sales for March total 20,800

will give a good review for the quick answer! Just need help with 10 A & B on the bottom.

will give a good review for the quick answer! Just need help

  1. Sales for March total 20,800 units. Forecasted sales in units are as follows: April, 20,800; May, 21,600; June, 20,900; and July, 20,800. Sales of 242,000 units are forecasted for the entire year. The product's selling price is $25.00 per unit and its total product cost is $21.00 per unit.
  2. Company policy calls for a given month's ending raw materials inventory to equal 50% of the next month's materials requirements. The March 31 raw materials inventory is 5,360 units, which complies with the policy. The expected June 30 ending raw materials inventory is 4,200 units. Raw materials cost $20 per unit. Each finished unit requires 0.50 units of raw materials.
  3. Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's expected unit sales. The March 31 finished goods inventory is 16,640 units, which complies with the policy.
  4. Each finished unit requires 0.50 hours of direct labor at a rate of $17 per hour.
  5. Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $3.00 per direct labor hour. Depreciation of $21,100 per month is treated as fixed factory overhead.
  6. Sales representatives' commissions are 8% of sales and are paid in the month of the sales. The sales manager's monthly salary is $3,200.
  7. Monthly general and administrative expenses include $14,000 administrative salaries and 0.7% monthly interest on the long-term note payable.
  8. The company expects 30% of sales to be for cash and the remaining 70% on credit. Receivables are collected in full in the month following the sale (none are collected in the month of the sale).
  9. All raw materials purchases are on credit, and no payables arise from any other transactions. One month's raw materials purchases are fully paid in the next month.
  10. The minimum ending cash balance for all months is $42,000. If necessary, the company borrows enough cash using a short-term note to reach the minimum. Short-term notes require an interest payment of 1% at each month-end (before any repayment). If the ending cash balance exceeds the minimum, the excess will be applied to repaying the short-term notes payable balance.
  11. Dividends of $12,000 are to be declared and paid in May.
  12. No cash payments for income taxes are to be made during the second calendar quarter. Income tax will be assessed at 40% in the quarter and paid in the third calendar quarter.
  13. Equipment purchases of $132,000 are budgeted for the last day of June.

with 10 A & B on the bottom. Sales for March total

20,800 units. Forecasted sales in units are as follows: April, 20,800; May,

ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 42,000 364,000 107,200 349,440 862,640 604,000 (152,000) 452,000 $1,314,640 $ 211,300 14,000 225,300 510,000 735,300 337,000 242,340 579,340 $1,314,640 ZIGBY MANUFACTURING Weighted Average Cost per Raw Material unit Costs: March 31 Raw Material Balance (connect) Raw Material purchases (total from 3 net of discount) Total Costs available for use in production (a) Units: Units in 3/31 Raw Material inventory (connect) Units purchased during quarter (from 3) Total units available for production (b) Weighted-Average Cost per unit (a) (b) show 2 decimals 107,200 607,826 $715,026 5,360 30,490 35,850 $19.94 b) Use the weighted average cost per unit to calculate the June 30 raw material inventory balance and the cost of direct material used in production. Use the notes below the table for assistance ZIGBY MANUFACTURING Raw Material Inventory Allocation of Costs Inventory at Used in 6/30 Production Units 4,200 10,410 Weighted average cost per unit $19.94 $19.94 Allocated costs $83.748 $207,575.40 Total Accounted for 14,610 $19.94 $291,323.40 10) Connect gives a total product cost per unit that is used to calculate the ending inventory value and cost of goods sold. This per unit cost includes fixed overhead costs assuming the quarter's original production and sales levels. This average will change because of the one-time sale. Zigby Manufacturing uses weighted average costing for its inventory. Because Zigby does not have any Work-In-Process inventory, we can assume that all production costs flow to finished goods and then to cost of goods sold. a) Follow the directions below the table to calculate the revised weighted average cost per unit. ZIGBY MANUFACTURING Weighted Average Cost per Finished Goods Inventory Costs: March 31 Finished Goods Inventory (connect) Raw Material used in production (calculated in 9) Budgeted Direct Labor costs (calculated in 4 including wage premium) Budgeted Overhead Costs (calculated in 5.Both variable and fixed) Total Costs of Finished Goods available for use sale (a) Units: Units in 3/31 Finished Goods Inventory (connect) Units produced during quarter (from 2) Total units available for sale (b) Weighted-Average Cost per unit (a)(b) show 2 decimals 349,440 715,026 739,770 18,120 b) Use the weighted average cost per unit to allocate costs between 6/30 finished goods inventory and COGS. ZIGBY MANUFACTURING Finished Goods Inventory Allocation of Costs FG Inventory at Sold 6/30 Units Weighted average cost per unit Allocated costs Total Accounted for ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 42,000 364,000 107,200 349,440 862,640 604,000 (152,000) 452,000 $1,314,640 $ 211,300 14,000 225,300 510,000 735,300 337,000 242,340 579,340 $1,314,640 ZIGBY MANUFACTURING Weighted Average Cost per Raw Material unit Costs: March 31 Raw Material Balance (connect) Raw Material purchases (total from 3 net of discount) Total Costs available for use in production (a) Units: Units in 3/31 Raw Material inventory (connect) Units purchased during quarter (from 3) Total units available for production (b) Weighted-Average Cost per unit (a) (b) show 2 decimals 107,200 607,826 $715,026 5,360 30,490 35,850 $19.94 b) Use the weighted average cost per unit to calculate the June 30 raw material inventory balance and the cost of direct material used in production. Use the notes below the table for assistance ZIGBY MANUFACTURING Raw Material Inventory Allocation of Costs Inventory at Used in 6/30 Production Units 4,200 10,410 Weighted average cost per unit $19.94 $19.94 Allocated costs $83.748 $207,575.40 Total Accounted for 14,610 $19.94 $291,323.40 10) Connect gives a total product cost per unit that is used to calculate the ending inventory value and cost of goods sold. This per unit cost includes fixed overhead costs assuming the quarter's original production and sales levels. This average will change because of the one-time sale. Zigby Manufacturing uses weighted average costing for its inventory. Because Zigby does not have any Work-In-Process inventory, we can assume that all production costs flow to finished goods and then to cost of goods sold. a) Follow the directions below the table to calculate the revised weighted average cost per unit. ZIGBY MANUFACTURING Weighted Average Cost per Finished Goods Inventory Costs: March 31 Finished Goods Inventory (connect) Raw Material used in production (calculated in 9) Budgeted Direct Labor costs (calculated in 4 including wage premium) Budgeted Overhead Costs (calculated in 5.Both variable and fixed) Total Costs of Finished Goods available for use sale (a) Units: Units in 3/31 Finished Goods Inventory (connect) Units produced during quarter (from 2) Total units available for sale (b) Weighted-Average Cost per unit (a)(b) show 2 decimals 349,440 715,026 739,770 18,120 b) Use the weighted average cost per unit to allocate costs between 6/30 finished goods inventory and COGS. ZIGBY MANUFACTURING Finished Goods Inventory Allocation of Costs FG Inventory at Sold 6/30 Units Weighted average cost per unit Allocated costs Total Accounted for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!