Co.B provides the following unit sales forecast for the next three months: Jay August 61 54 00 00 September 506 0 The company wants to end each month with ending finished goods inventory equal to 20% of the next month's sales. Finished goods inventory un June 30 1080 units. The budged produdien unes for pa Ⓒ4320 units 2100 unis 5540 O6480 unts

Co.B provides the following unit sales forecast for the next three months: Jay August 61 54 00 00 September 506 0 The company wants to end each month with ending finished goods inventory equal to 20% of the next month's sales. Finished goods inventory un June 30 1080 units. The budged produdien unes for pa Ⓒ4320 units 2100 unis 5540 O6480 unts

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter8: Budgeting

Section: Chapter Questions

Problem 2CMA

See similar textbooks

Similar questions

Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
JNT Store expets to generate the following sales for the next three months: August September October Expected sales 460,000 580,000 620,000 JNT's cost of goods sold is 60% of sales dollars. At the end of each month, BW wants a merchandise inventory balance equal to 20% of the following month's expected cost of goods sold. What dollar amount of desired ending merchandise inventory ojnt in September?
For the month of July, a company estimated that unit sales and required production are 26,600 units and 25,175 units, respectively. The company always maintains ending finished goods inventory equal to 25% of the next month's unit sales. What is the estimated unit sales for August? Multiple Choice 22,868 units 15,900 units 17,868 units 20,900 units MacBook Air F11 F12 F9 F10 F7 F8 身
ABCL Corporation predicts the following sales in units for the coming four months: May June July August September Unit sales …… 400 500 520 480 540 Finished goods inventory on April 30: 120 units Raw materials inventory on April 30: 450 pounds Desired ending inventory each month: Finished goods: 30% of next month's sales Raw materials: 25% of next month's production needs Number of pounds of raw material required per finished unit: 4 lbs. Required: How many pounds of raw materials should be purchased in May?
Wildhorse Ltd. estimates sales for the second quarter of 2022 will be as follows. Month April May June Units March 31 April 30 May 31 June 30 3,090 3,190 2,960 The target ending inventory of finished products is as follows. 2,440 2,620 2,600 2,900 Two units of materials are required for each unit of finished product. Production for July is estimated at 3,210 units to start building inventory for the fall sales period. Wildhorse's policy is to have an inventory of raw materials at the end of each month equal to 50% of the following month's production requirements. Raw materials are expected to cost $4 per unit throughout the period. Calculate the May raw materials purchases in dollars. Raw material purchases cost
MNO Company forecast sales in units for July to November as follows: Units JULY - 4000 aUGUST - 4300 SEPTEMBER - 4500 OCTOBER - 4700 NOVEMBER - 5000 MNO Company would like to maintain 200 units in its ending inventory at the end of each month starting July. Ending inventory for the month of June is 150 units. Beginning inventory at the start of January amounts to 100 units. 1. How many units should MNO Company produce for the month of July to fulfill the expected sales of the company?
Truliant Co. sells a product called Withitall and has predicted the following sales for the first four months of the current year: January February March April Sales in units 17,000 1,900 2,100 1,600 Ending inventory for each month should be 20% of next month's sales. The number of units produced in February should be a.1,940 units b.1,900 units c.1,800 units d.1,850 units
JoAnn Manufacturing has projected the following sales for the coming year 01 02 03 04 Sales $53,475 $59,725 $ 68,775 $ 74,050 The company places orders each quarter that are 30 percent of the following quarter's sales and has a 30-day payables period. What is the payment of accounts for the third quarter? Mutiple Choice O $21.360.00 121687.50 $22.22969 $19,72750
Catulla Corporation predicts the following sales in units for the coming four months April May 240 200 June July 300 sales in units Each moners ending Finished Goods Inventory in units should be 40% of the next month's sales Mech 21 Fished Goods inventory a 00 unts A freshed unit requires five pounds of dract material 8 at a cost of $2.00 per pound. The March 31 Raw Materials inventory has 200 pounds of direct matal 8. Each moners ending Raw Materials twentary should be 30% of the following months production needs The budgeted purchases of pounds of direct material during May should be O 1422 pounds 4xpr 210 pan
JT Department Store expects to generate the following sales for the next three months: August $460,000 $580,000 September $620,000 July Expected sales... JT's cost of gods sold is 60% of sales dollars. At the end of each month, JT wants merchandise inventory balance equal to 20% of the following month's expected cost of goods sold. What dollar amount of merchandise inventory should JT plan to purchase in August? A. $352,800 correct answer don'4 know how to get it B. $327,800 C. $257,400 D. $314,600 6.
1. ABM Company forecasts sales in units for January to May as follows: January 2,500, February 2,700, March 3,500, April 3,700 and May 3,500 2. ABM Company would like to maintain 100 units in its ending inventory at the end of each month. 3. Beginning inventory at the start of January is S0 units. 4. How many units should ABM Company produce in order to fulfill the expected sales of the company? MONTH JAN FEB MARCH APRIL MAY TOTAL Projected Sales Target level of ending Inventories Total Less: beginning inventories Required production 5. assume selling price is PHP200/unit. 6, Sales for each month are expected to be collected as follows: • Month of sales : 20% A month after sales: 50% - 2 months after sales: 30%6 Note • On January Abm Company collected from previous month sales amounted to P100,000 MONTH JAN FEB MARCH APRIL MAY TOTAL Units Sales in Pesos Collection from current months sales Collection from previous months sales Collection from two months prior sales Total Collections…
Croy Incorporated has the following projected sales for the next five months: Month April May June July August Sales in Units 3,530 3,815 4,530 4,120 3,990 Croy's finished goods inventory policy is to have 50 percent of the next month's sales on hand at the end of each month. Direct materials cost $2.80 per pound, and each unit requires 2 pounds. Direct materials inventory policy is to have 50 percent of the next month's production needs on hand at the end of each month. Direct materials on hand at March 31 totaled 3,673 pounds. Required: 1. Determine budgeted production for April, May, and June. 2. Determine budgeted cost of direct materials purchased for April and May. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Determine budgeted production for April, May, and June. Note: Do not round your intermediate calculations and round your final answers to the nearest whole number. June Budgeted Production (Units) April May