Olympia, Inc. manufactures electric bicycles. The company desires to end each month with finished goods inventory equal to 10% of the next month’s sales. Please complete the following production budget ### Olympia, Inc.### Production Budget#### Quarter 2 - 2023*(all figures in units)*---**Sales**- **April:** 1,000 units- **May:** 800 units- **June:** 1,200 units**Plus: Desired ending finished goods inventory**- **June:** 100 units**Total finished goods inventory needed****Less: Estimated beginning finished goods inventory**- **April:** 80 units **Units to be produced**---This table represents the production budget for Olympia, Inc. for the second quarter of 2023. All figures are shown in units. The table details the sales forecast for each month — April, May, and June — as well as the desired ending inventory for the month of June. Additionally, it calculates the total finished goods inventory needed and subtracts the estimated beginning finished goods inventory for each month to determine the total units that need to be produced.

Production Budget -Production Budget is a part of the budgeting technique. Under this schedule of…

Olympia, Inc. manufactures electric bicycles. The company desires to end each month with finished goods inventory equal to 10% of the next month’s sales. Please complete the following production budget

Olympia, Inc. manufactures electric bicycles. The company desires to end each month with finished goods inventory equal to 10% of the next month’s sales. Please complete the following production budget

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

Zira Company reports the following production budget for the next four months. Each finished unit requires four pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 847 pounds. Direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) Units to produce April May June 706 760 738 Units to produce Materials required per unit Materials needed for production (pounds) Add: Desired ending materials inventory (pounds) Total materials required (pounds) Less: Beginning materials inventory (pounds) Materials to purchase (pounds) Materials cost per pound Cost of direct materials purchases July 718 ZIRA COMPANY Direct Materials Budget April $ $ 706 4 2,824 2,824 ↑ 5 $ 0 $ May 760 4 3,040 Saved 3,040 June 5 $ 0 $ 738 units 4 pounds 2,952 pounds 2,952 pounds 5 per pound 0…
Thunder Creek Company uses 2 pounds of direct materials for each unit it produces, at a cost of $4.00 per pound. The company begins the year with 9,500 pounds of material in Raw Materials Inventory. Management desires an ending inventory of 25% of next month's materials requirements Prepare a Direct Materials Budget. (When entering answers in the direct materials budget, use the production budget for your cell references. Enter all values as positive--without a minus sign--in row 31.) 2018 Jan Feb Q1 Total April Budget #3: Direct Materials Budget Budgeted units to be produced Mar 30,800 25,200 19,200 2.00 Direct materials (pounds) per unit 2.00 Direct materials needed for production 50,400 38,400 12,600 2.00 61,600 8,600 Plus: Desired direct materials in ending inventory (pounds) 15,400 Total direct materials needed 51,000 65,800 70,200 Less: Direct materials in beginning inventory (pounds) 9,500 12,600 15,400 Budgeted purchase of direct materials 41,500 53,200 54,800 Direct material…
Prepare a production budget for the first four months of the year. Cloud Shoes manufactures recovery sandals and is planning on producing 12,000 units in March and 11,500 in April. Each sandal requires 1.2 yards if material, which costs $3.00 per yard. The company’s policy is to have enough material on hand to equal 15% of next month’s production needs and to maintain a finished goods inventory equal to 20% of the next month’s production needs. What is the budgeted cost of purchases for March?
Shadee Corporation expects to sell 630 sun shades in May and 320 in June. Each shade sells for $162. Shadee's beginning and ending finished goods inventories for May are 60 and 50 shades, respectively. Ending finished goods inventory for June will be 55 shades. Required: 1. Prepare Shadee's sales budget for May and June. 2. Prepare Shadee's production budget for May and June.
Dolson Appliances makes coffee machines for offices and homes. For next year, the production budget is 141,000 units. Beginning inventories will be 18,000 units and the desired ending inventory will be 16,000 units. Required: What is the sales budget for the coming year for Dolson Appliances? Sales budget units
Magnolia Interior décor Industries manufactures wooden dining chairs. The selling price of the wooden dining chairs is $15 per unit. The company is preparing detailed budgets for the third quarter (Third quarter includes July, August and September) and fourth quarter (Fourth quarter includes October, November and December) and has assembled the following information to assist in the budget preparation (see below tables). Sales for June totaled $2,000. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. Calculate the estimated quantity of wooden dining chairs that need to be produced in July. Estimated unit sales for the next several month Month Units July 100 August 200 September 300 October 200 November 200 300 December All sales are on account (i.e., on credit). These sales on account are usually collected in the following pattern: 65% in the month following sale 5% X 130 Correct Answer: 115…
Furniture, Inc. makes and sells a single product called a Bik. The company wants to prepare the direct material budget for the quarter ending June 30. Budgeted production of Biks for the next six months is as follows: February 14,000 Units March 15,500 Units April 11,900 Units May 12,600 Units June 14,500 Units July 16,000 Units It takes three yards of Material A to make one Bik. The company wants to maintain monthly ending inventory of Material A equal to 20% of the following month's production needs. On March 31, 2,000 yards of Material A were on hand. The cost of Material A is $5 per yard. Required: 1. Prepare the Direct Materials Budget for April, May, June, and quarter. 2. Based on the direct material budget that you prepared in requirement 1 above and assume that the direct materials purchase in February was $150,000 and in March was $160,000. Prepare the cash disbursements budget for April if the company policy for paying purchases is as follows: 10% in the month of purchase.…
Zira Company reports the following production budget for the next four months. Each finished unit requires five pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 20% of next month's production needs, Beginning direct materials inventory for April was 634 pounds. Direct materials cost $6 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) April May 675 June July Units to produce 634 667 647 ZIRA COMPANY Direct Materials Budget April May June Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Cost of direct materials purchases
The Simmons Company finished their sales projections for the coming year. The company produces one product. Part of next year's sales projections are as follows. Projected Sales in Units July 125,000 August 145,000 September 139,000 October 155,000 November 180,000 The budget committee has also completed the following information on inventories. Raw Materials Ending Balance, June, 50,000 lbs Desired ending levels (monthly 10% of next month's production needs) Work-In-Progress None Finished Goods Inventory Ending Balance, June, 22,000 units Desired ending levels: 20% of next month's sales The Engineering Department has developed the following standards upon which the production budgets will be developed. Item Standard Material usage 3 pounds per unit Material price per pound $2.00 per pound Labor usage 0.5 hours per unit Labor rate $40 per hour Machine hours 2 machine hours per unit The Simmons Company uses a modified allocation method for…
Zira Company reports the following production budget for the next four months. Each finished unit requires six pounds of direct materials, and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 1,156 pounds. Direct materials cost $5 per pound. Prepare a direct materials budget for April, May, and June. (Round your answers to the nearest whole number.) April May 642 670 Units to produce Units to produce Materials needed for production (pounds) Total materials required (pounds) Materials to purchase (pounds) Cost of direct materials purchases June 676 July 656 ZIRA COMPANY Direct Materials Budget April May June
Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods Inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,600 finished surfboards In Inventory. Budgeted sales units July 4,000 August 5,500 September 4,200 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Desired ending inventory units Total required units Units to be produced July August
jeremy inc. produces leather handbags. The production budget for the next four months is:July 5000 units, August 7300, September 7500, October 8800. Eachhandbag requires 0.5 square meters of leather. Jeremy inc's leather inventory policy is 30 percent of next month's production needs. If the leather policy is met, what will the july 1 inventory be?750.0 square meters1095.0 square meters1825.0 square meters300.0 square meters