Crane Company produces and sells automobile batteries, the heavy-duty HD-240. The 2022 sales forecast is as follows. Quarter HD-240 1 2 3 4 6,300 8,820 10,080 12,600 The January 1, 2022, inventory of HD-240 is 2,520 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022.

Crane Company produces and sells automobile batteries, the heavy-duty HD-240. The 2022 sales forecast is as follows. Quarter HD-240 1 2 3 4 6,300 8,820 10,080 12,600 The January 1, 2022, inventory of HD-240 is 2,520 units. Management desires an ending inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 2023 are expected to be 25% higher than sales in the same quarter in 2022.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 8EB: How many units are estimated to be sold if Kino, Inc., has planned production of 750,000 units, a...

See similar textbooks

Similar questions

How many units are estimated to be sold if Kino, Inc., has planned production of 750,000 units, a desired beginning inventory of 30,000 units, and a desired ending inventory of 45,000 units?
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.
Refer to Cornerstone Exercises 2.2 and 2.3. Next year, Pietro expects to produce 50,000 units and sell 49,300 units at a price of 12.50 each. Beginning inventory of finished goods is 42,500, and ending inventory of finished goods is expected to be 34,000. Total selling expense is projected at 26,000, and total administrative expense is projected at 134,000. Required: 1. Prepare an income statement in good form. Be sure to include the percent of sales column. 2. What if the cost of goods sold percentage for the past few years was 65 percent? Explain how management might react.
Ottis, Inc., uses 640,000 plastic housing units each year in its production of paper shredders. The cost of placing an order is 30. The cost of holding one unit of inventory for one year is 15.00. Currently, Ottis places 160 orders of 4,000 plastic housing units per year. Required: 1. Compute the annual ordering cost. 2. Compute the annual carrying cost. 3. Compute the cost of Ottiss current inventory policy. Is this the minimum cost? Why or why not?
Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2020 sales forecast is as follows. Quarter HD-240 1 5,100 2 7,410 3 8,180 4 10,470 The January 1, 2020, inventory of HD-240 is 2,040 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2021 are expected to be 25% higher than sales in the same quarter in 2020.Prepare quarterly production budgets for each quarter and in total for 2020. TURNEY COMPANYProduction Budgetchoose the accounting period For the Year Ending December 31, 2020For the Month Ended December 31, 2020For the Quarter Ended December 31, 2020 Product HD-240 Quarter 1 2 3 4 Year select an opening production budget item Beginning Finished Goods UnitBeginning Direct MaterialsDesired…
For the first quarter of 2021, the target sales amount to 500,000 units. For the months of January, February and March,these sales be spread at 25%, 30% and 45% respectively. The cost per unit would be P200. It is the policy of the firm to maintain 20%of the next month’s sales as ending inventory of the current month. The beginning balance of the year for inventories and accountspayable are P5,000,000 (25,000 units at P200/unit) and P20,000,000 respectively. The payables are to be fully paid in January. Thebudgeted sales for April is 240,000 units. Only 20% of payables are paid during the month of purchase with the remaining settled inthe month after purchase. Find the budgeted cost of sales, targeted ending inventory balance required purchases and targeted ending accounts payable for the month of January, February and March January February March Budgeted Cost of Sales Targeted Ending Inventory Balance Required Purchaes Targeted Ending Accounts Payable…
Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 1 5,100 2 7,320 3 8,280 4 10,430 The January 1, 2017, inventory of HD-240 is 2,040 units. Management desires an ending inventory each quarter equal to 40% of the next quarter’s sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in the same quarter in 2017.Prepare quarterly production budgets for each quarter and in total for 2017. TURNEY COMPANYProduction Budgetchoose the accounting period Product HD-240 Quarter 1 2 3 4 Year select an opening Production Budget item Enter a number of units Enter a number of units Enter a number of units Enter a number of units select between addition and deduction…
You would like to know how much should your business purchase for the month of February 2020. The December 2019 sales is 50,000 units and this is expected to increase by 1% per month. The inventory balance as of Dec. 31, 2019 is 4,000 units and you aim to maintain 10% of the month’s sale already to be on hand at the beginning of each month. So far, it is likely that the forecast for January will be achieved. Assuming that cost per unit is maintained at P40, how much would the total purchases be for February? *Note round OFF forecasted units to be sold to whole numbers and round UP the required balance to whole numbers. Thank you in advance, I really appreciate your help ^_^
You would like to know how much should your business purchase for the month of February 2020. The December 2019 sales is 50,000 units and this is expected to increase by 1% per month. The inventory balance as of Dec. 31, 2019 is 4,000 units and you aim to maintain 10% of the month’s sale already to be on hand at the beginning of each month. So far, it is likely that the forecast for January will be achieved. Assuming that cost per unit is maintained at P40, how much would the total purchases be for February? *Note round OFF forecasted units to be sold to whole numbers and round UP the required balance to whole numbers.
Crane Ltd. estimates sales for the second quarter of 2022 will be as follows. Month Units April 3,190 May 3,290 June 3,060 The target ending inventory of finished products is as follows. March 31 2,520 April 30 2,700 May 31 2,680 June 30 3,000 Two units of materials are required for each unit of finished product. Production for July is estimated at 3,310 units to start building inventory for the fall sales period. Crane’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.
Grey Manufacturing Company expects sales to total 18,600 units in the first quarter, 16,000 units in the second quarter, and 23,000 units in the third quarter of the current fiscal year. Company policy is to have on hand at the end of each quarter an amount of inventory equal to 10% of the following quarter’s sales. Given this information, how many units should be scheduled for production in the second quarter?
Furniture, Inc., estimates the following number of mattress sales for the first four months of 2024: Month Sales January 10,000 February 14,000 March 13,000 April 16,000 Finished goods inventory at the end of December is 3,000 units. Target ending finished goods inventory is 30% of the next month's sales. How many mattresses need to be produced in January 2024? A) 8,800 mattresses B) 11,200 mattresses C) 13,000 mattresses D) 14,200 mattresses