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

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

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

Silver Company makes a product with peak sales in May of each year. Its sales budget for the second quarter is given below: Budgeted sales (all on account) April $ 320,000 May $520,000 June $ 180,000 Total $ 1,020,000 The company estimates 30% of a month's sales are collected in the month of sale, another 65% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $250,000, and March sales totaled $280,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. Schedule of Expected Cash Collections April February sales March sales $ 12,500 182,000…
Zahn Co. predicts sales of 246 units in May and 500 units in June. Each month’s ending inventory should be 25% of the next month’s sales. The April 30 ending finished goods inventory is 120 units. Compute budgeted production (in units) for May. Budgeted production (in units)
Frolic Corporation has budgeted sales and production over the next quarter as follows: September ? 61,150 Sales in units Production in units Multiple Choice 68,750 The company has 4,900 units of product on hand at July 1. 10% of the next month's sales in units should be on hand at the end of each month. October sales are expected to be 76,000 units. Budgeted sales for September would be (in units): 59,500 July 44,500 45,250 66,800 August 56,500 56,800
Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 153 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units. April 510 Budgeted sales units Add: Desired ending inventory Next period budgeted sales units Ratio of inventory to future sales Budgeted beginning inventory units Total required units Units to produce May 590 RUIZ COMPANY Production Budget April June 540 590 30% July 630 May 540 30% June 630 30%
Blue Wave Co. predicts the following unit sales for the coming four months: September, 3,300 units; October, 4,900 units; November, 6,700 units; and December, 7,900 units. The company's policy is to maintain finished goods inventory equal to 50% of the next month's sales. At the end of August, the company had 2,800 finished units on hand. Prepare a production budget for each of the months of September, October, and November. Blue Wave Co. Production Budget September, October and November September Next month's budgeted sales (units) Units to be produced % October % November %
ABC Company’s budgeted sales for June, July, and August are 12,800, 16,800, and 14,800 units, respectively. ABC requires 30% of the next month’s budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 3,840 units. Required: Calculate the number of units to be produced in June and July.
Collins Company is preparing its master budget for April. Use the given estimates to determine the amounts necessary for each of the following requirements. (Estimates may be related to more than one requirement.) a. What should total sales revenue be if territories A and B estimate sales of 10,000 and 13,000 units, respectively, and the unit selling price is $43? b. If the beginning finished goods inventory is an estimated 2,000 units and the desired ending inventory is 3,000 units, how many units should be produced? c. What dollar amount of material should be purchased at $4 per pound if each unit of product requires 3 pounds and beginning and ending materials inventories should be 5,000 and 4,000 pounds, respectively? d. How much direct labor cost should be incurred if each unit produced requires 1.5 hours at an hourly rate of $14? e. How much manufacturing overhead should be incurred if fixed manufacturing overhead is $52,000 and variable manufacturing overhead is $2.50 per…
Harris Inc., has budgeted sales in units for the next five months as follows: June July August September October 9,400 units 7,800 units 7,300 units 5,400 units 4,100 units Past experience has shown that the ending inventory for each month should be equal to 20% of the next month's sales in units. The inventory on May 31 contained 1,880 units. The company needs to prepare a production budget for the next five months.
Tyler Company budgets the following unit sales for the next four months: April, 3,800 units; May, 4,600 units; June, 6,900 units; and July, 2,800 units. The company's policy is to maintain finished goods inventory equal to 30% of the next month's unit sales. At the end of March, the company had 1,140 finished units in inventory. Prepare a production budget for each of the months of April, May, and June. Next period budgeted sales units Desired ending inventory units Total required units Units to produce TYLER COMPANY Production Budget April % May % June %
Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $400,000 for April and $480,000 for May. Cost of goods sold is expected to be 65% of sales. The company’s desired ending inventory is 20% of the following month’s cost of goods sold.Compute the required purchases for April. Moore WholesalersPurchases Budget $ : : $
Getty Company expects sales for the first three months of next year to be $205,000, $270,000 and $300,000, respectively. Getty expects 30 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March. February March Budgeted cash receipts
Tram Industries is preparing its budget for the upcoming year. For the month of August, unit sales are budgeted at 17,600 units and production is budgeted at 17,750 units. Ending inventory is budgeted at 30% of the next month's unit sales. What are the budgeted unit sales in September? O 17,140 units 17,390 units 18,100 units O 19,060 units O None of the above