Prepare a quarterly production budget. Assume that the sales forecast for the first quarter of the following year is the same as the firstquarter forecast for this year.QuarterFirstSecondThirdFourth8000240002900040000ventory360043506000d.1160028350350003 Inventoryrements The sales forecast for birdhouses built by Splish Enterprises follows. Beginning inventory for the year is expected to be 8,000birdhouses, and the production manager prefers to maintain an ending inventory of 15% of the next quarter's sales.QuarterNumber of BirdhousesFirst8,000Second24,000Third29,000Fourth40,000

The production budget is prepared to know how much production should be done in order to support the…

Prepare a quarterly production budget. Assume that the sales forecast for the first quarter of the following year is the same as the first quarter forecast for this year. Quarter First Second Third Fourth 8000 24000 29000 40000

Prepare a quarterly production budget. Assume that the sales forecast for the first quarter of the following year is the same as the first quarter forecast for this year. Quarter First Second Third Fourth 8000 24000 29000 40000

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

Waterway Company estimates that unit sales will be 10, 100 in quarter 1;12,500 in quarter 2:14,200 in quarter 3; and 17,700 in quarter 4. Management wants to have an ending finished goods inventory equal to 21% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first six months of 2022
Also include the total of the six months
4. Prepare a cash budget by quarter and in total for next year.
Infinity Inc. has provided the following projected sales units for the next quarter: Projected Sales Units for Next Quarter Sales Units First month Second month Third month Projected sales units 10,000 12,000 15,000 Desired ending inventory is determined to be 10% of the next month’s projected sales. What would be the budgeted production units during the second month of the quarter? Group of answer choices 12,300 units 13,200 units 11,700 units 13,500 units
Champ Incorporated budgets the following sales in units for the coming two months. Each month's ending Inventory of finished units should be 60% of the next month's sales. The April 30 finished goods Inventory is 168 units. May 280 Budgeted sales units Prepare the production budget for May. CHAMP, INCORPORATED Production Budget June 200 Next period budgeted sales units Ratio of inventory to future sales Add: Desired ending inventory Next period budgeted sales units Desired ending inventory units Total required units Less: Beginning inventory units Units to produce May
If the expected sales volume for the current period is 9,000 units, the desired ending inventory is 200 units, and the beginning inventory is 300 units, the number of units set forth in the production budget, representing total production for the current period, is a. 9,000 units b. 9,100 units c. 8,700 units d. 8,900 units
Parker corp which operates on a calendar year, expects to sell 6000 units in october and expects sales to increase 10% each month there after. Sales price is expected to stay constant at 17 per unit. what are budgeted revenues for the fourth quarter?102,000 306,000336,600337,620
Rolling Financial Forecasts You are given the following budgeted and actual data for the GreyCompany for each of the months January through June of the current year.In December of the prior year, sales were forecasted as follows: January, 100 units; February, 95units; March, 100 units; April, 110 units; May, 120 units; June, 125 units. In January of the currentyear, sales for the months February through June were re-forecasted as follows: February, 90 units;March, 100 units; April, 105 units; May, 110 units; June, 120 units. In February of the current year,sales for the months March through June were reforecasted as follows: March, 95 units; April, 105units; May, 105 units; June, 120 units. In March of the current year, sales for the months Aprilthrough June were reforecasted as follows: April, 105 units; May, 100 units; June, 110 units. In Aprilof the current year, sales for the months May and June were reforecasted as follows: May, 90 units;June, 105 units. In May of the current…
on 4 obinson Corp., which operates on a calendar year, expects to sell 1380 units in October, and expects sales to increase 130 units each month thereafter. Sales price expected to stay constant at $7 per unit. What are budgeted sales revenue for the fourth quarter? << < Question 4 of 5
PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULAS PLEASE, DO IT IN EXCEL AND SHOW THE FORMULASIn preparing the cash budgeting projected balance method, it is necessary to calculate the amount of the inventory balance. The following information is available for the current fiscal year: Inventory balance, $200,000.00, it is known that the inventory turnover is every 60 days. The Cost of Sales is forecasted to increase 15% for the next fiscal year. What is the budgeted inventory balance
BUDGETED INCOME STATEMENT The Out West Division of XYZ has been asked to prepare a quarterly budgeted income statement for 2020. The regional manager expects that sales in the first quarter of 2020 will increase in volume by 10% over the same quarter of the preceding year and will then increase by 5% for each succeeding quarter in 2020. The corporate head office has requested that the regional manager sustain an inventory in pesos equal to 16% of the next quarter’s sales. Quarterly purchases average 45% of quarterly sales. Budgeted ending inventory on December 31, 2019 is P8,000. Quarterly salaries are P7,200 plus 10% of sales. All salaries are classified as sales salaries. Other quarterly expenses are estimated as follows: Rent expense P4,400 Depreciation on office equipment P2,000 Utilities expense P1,800 Miscellaneous expenses 2% of sales The income statement information…
Mooney Equipment is putting together its cash budget for the following year and has forecasted expected cash collections over the next five quarters (one year plus the first quarter of the next year). The cash collection estimates are based on sales projections and expected collection of receivables. The sales and cash collection estimates are shown in the following table (in millions of dollars): Q1 Q2 Q3 Q4 Q5 Sales $1,100 $1,400 $1,450 $1,250 $1,500 Total cash collections $1,100 $1,150 $1,200 $1,200 You also have the following information about Mooney Equipment: • In any given period, Mooney’s purchases from suppliers generally account for 72% of the expected sales in the next period, and wages, supplies, and taxes are expected to be 15% of next period’s sales. • In the third quarter, Mooney expects to expand one of its plants, which will require an additional $1,072 million investment. • Every quarter, Mooney pays $60 million in interest and…