5 years winery master budget

complete a draft 5 year financial model
The target:
1. case volume sales and profitability,and owners’ equity for the year ended 30 July 2017 are to be significantly higher than for the year ended 30 June 2012
2. stock levels must at all times be appropriate for forward sales projections using the stock to sales ratio as guideline

get more
3. the closing cash balance must never exceed the pre-arranged overdraft facilities
4. provide strategic sales forecasts for a 5 year period an the financial spread sheet need to cover these 5 years

Order Now

Electra Manufacturing, Inc., produces control valves used in the production of oil field equipment. The control valves are sold to various gas and oil engineering companies throughout the United States. Projected sales in units for the coming four months are as follows: January ……………… 20,000 February …………….. 25,000 March ……………….. 30,000 April ………………… 30,000 The following data pertain to production policies and manufacturing specifications followed by Electra: a. Finished goods inventory on January 1 is 13,000 units. The desired ending inventory for each month is 70 percent of the next month’s sales. b. The data on materials used are as follows:

https://www.profoundessaywriters.com/

.:. Inventory policy dictates that sufficient materials be on hand at the…show more content…
labor cost $ 735,000 $ 855,000 $ 900,000 $ 2,490,000 5. Schedule 5: Overhead budget January February March Total Budgeted direct labor hours (Schedule 4) 49,000 57,000 60,000 166,000 Variable overhead rate × $3.90 × $3.90 × $3.90 × $3.90 Budgeted var. overhead $ 191,100 $ 222,300 $ 234,000 $ 647,400 Budget fixed overhead 205,000 205,000 205,000 615,000 Total overhead $ 396,100 $ 427,300 $ 439,000 $ 1,262,400

Leave a Reply