Imagine you are an owner of a company. Listed below are your budgeted monthly unit sales sold at P10 per unit. March April May June July Budgeted Monthly Unit Sales 2,000.00 3,000.00 4,000.00 5,000.00 4,500.00 The desired finished goods inventory balance is 20% of the budgeted monthly unit sales of the following month. The beginning balance of finished goods inventory in April amounted to 500 units while the desired ending balance of finished goods inventory in June amounted to 500 units. Using the table below, prepare a production budget for the month of April, May and June. Production Budget April May June Total Budgeted Unit Sales Add: Desired ending finished goods inventory Total Needs Less: Beginning finished goods inventory Required production in units

Imagine you are an owner of a company. Listed below are your budgeted monthly unit sales sold at P10 per unit. March April May June July Budgeted Monthly Unit Sales 2,000.00 3,000.00 4,000.00 5,000.00 4,500.00 The desired finished goods inventory balance is 20% of the budgeted monthly unit sales of the following month. The beginning balance of finished goods inventory in April amounted to 500 units while the desired ending balance of finished goods inventory in June amounted to 500 units. Using the table below, prepare a production budget for the month of April, May and June. Production Budget April May June Total Budgeted Unit Sales Add: Desired ending finished goods inventory Total Needs Less: Beginning finished goods inventory Required production in units

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?
FRANCORP is preparing budgets for the quarter ending March 31. Budgeted sales for the next 5 months are as follows: January February March April May 16250 units 16950 units 17200 units 18350 units 17900 units The selling price per unit is $15. Determine the total budgeted sales for the month of March. O $195.500 O $200,900 $238,550 O $258,000
The following is a schedule of the projected unit sales of Western Company, which manufactures casual wear. Each unit sells for $25. The company began the period with a beginning accounts receivable balance of $10,000. Choose the correct answer from the options provided. Budgeted unit sales Percentage of sales collected in the quarter of the sale Percentage of sales collected in the quarter after the sale. Quarter First Second Third Fourth 1,500 1,300 1,400 1,300 Knowledge Check 01 What is the amount of budgeted sales revenue for the fourth quarter? O $32,500 $33,750 O $35,000 $37,500 $8,125 O $8,750 O $9,375 O $28,125 Year 5,500 75% 25% Knowledge Check 02 What is the amount of cash that is expected to be collected during the second quarter as a result of sales made during the first quarter?
Neon Inc. has a finished goods inventory of 20,000 units on July 1. The projected sales for July, August and September are 80,000 units, 90,000 units and 100,000 units, respectively. Its desired ending inventory is estimated as 20% of the current month’s budgeted sales. Determine the budgeted production for July. Group of answer choices 116,000 units 16,000 units 96,000 units 76,000 units
The marketing department of Teddy Bear Company has submitted the following sales forecast for the upcoming fiscal year. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 120,000 130,000 125,000 125,000 The company expected to start the first quarter with 20,000 units in finished goods in inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter s 25,000 units. Prepare the company’s production budget for the second quarter.
The following information applies to questions 25 and 26 The sales budget for Fred Limited contains the following information: October November December Units 300 550 700 $ (thousands) 75,000 165,000 210,000 Sales are all on credit, with 30% collected in the month of sale and 70% in the following month. Finished goods inventory at the end of each month should be 58% of the following month's sales requirements. Prepare a finished goods inventory budget and use it to answer Following Calculate the closing finished goods inventory, in units, for October. Calculate the required production, in units, for October.
Answer the questions from the information provided. 2.1 Use the information provided below to calculate the number of units of Product Tex that must be produced for July and August. INFORMATION The estimated sales volume of Product Tex is 25 000 units for June, 21 000 units for July, 30 000 units for August and 36 000 units for September. The policy of management is to maintain an ending finished goods inventory each month equal to 20% of the current month’s budgeted sales and 30% of the following month’s budgeted sales. 2.2 Study the information provided below and calculate the expected value of closing inventory as at 31 December 2022, if the FIFO method of inventory valuation is used. INFORMATION The following information was supplied by Sunbeam Manufacturers for 2022 in respect of its finished goods: R Inventory on 01 January 640 000 Cost of production of finished goods manufactured 570 000 Cost of goods sold 435 000 Sales value of the goods sold…
COVID19Co produces hand tools. A sales budget for the next four months is as follows March10.700 units, April 13.600, May 16,200, and June 21.200 COVID19Co's ending finished goods inventory policy is 10% of the following month's sales. What is budgeted ending finished goods inventory for March?
Lexi Company budgets unit sales of 1,510,000 in April, 1,210,000 in May, 320,000 in June, and 1,940,000 in July. Beginning inventory on April 1 is 604,000 units, and the company wants to have 40% of next month's unit sales in inventory at the end of each month. The merchandise cost per unit is $0.50. Prepare a merchandise purchases budget for the months of April, May, and June. LEXI COMPANY Merchandise Purchases Budget April May June Next period budgeted sales units Ratio of inventory to future sales Total required units Units to purchase Cost per unit Cost of merchandise purchases $ $ $
The marketing department of IKEA Inc. has submitted the following sales forecast for the upcoming fiscal year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales 7,000 6,000 10,000 8,000 The company expects to start the first quarter with 1,500 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,100 units. Each unit requires 0.75 direct labor-hours, and direct laborers are paid $16.00 per labor hour. The variable portion of its predetermined manufacturing overhead rate is $ 4 per direct labor-hour and its total fixed manufacturing overhead is $35,000 per quarter. The only noncash item included in fixed manufacturing overhead is depreciation, which is $8,000 per quarter. The company’s variable selling and administrative expense per unit is $7.50. Fixed selling and administrative expenses include…
The management of Jewel Company plans to have a finished goods inventory at the end of each month equal to 10% of the next month's sales. Budgeted sales in units over the next three months are 60,000 in October, 100,000 in November, and 120,000 in December. Budgeted Sales for January is 120,000. The beginning finished goods inventory for October is 60,000. REQUIRED: Compute for budgeted number of units to be produced in October, November and December. Use the template below: October November December Budgeted unit sales Add desired ending finished goods inventory Total needs Less beginning finished goods inventory Required production in units
ABC Company's budgeted sales for June, July, and August are 13,800, 17,800, and 15,400 units, respectively. ABC requires 40% of the next month's budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 5,520 units. Required: Calculate the number of units to be produced in June and July. Number of units June July