Vaughn Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on forecasted sales, Vaughn has developed the following budgeted production for the coming year. 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 1st Quarter Next Year Forecasted production (gallons) 5,000 7,000 9,000 12,500 6,000 Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Vaughn $0.15. An ounce of CA38 costs the company $0.25. Vaughn's inventory policy requires ending inventory equal to 20% of the next quarter's production needs. At the beginning of the year, Vaughn expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on hand. Prepare Vaughn's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.)
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Vaughn Chemicals has developed a new window cleaner that requires two ingredients, AM972 and CA38. Based on
1st Quarter
|
2nd Quarter
|
3rd Quarter
|
4th Quarter
|
1st Quarter
Next Year |
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Forecasted production (gallons)
|
5,000 | 7,000 | 9,000 | 12,500 | 6,000 |
Each gallon of window cleaner requires 100 ounces of AM972 and 28 ounces of CA38. An ounce of AM972 costs Vaughn $0.15. An ounce of CA38 costs the company $0.25. Vaughn's inventory policy requires ending inventory equal to 20% of the next quarter's production needs. At the beginning of the year, Vaughn expects to have 80,000 ounces of AM972 and 30,000 ounces of CA38 on hand.
Prepare Vaughn's AM972 purchases budget for the coming year. (Enter price per ounce to 2 decimal places, e.g. 0.35.)
1st Quarter
|
2nd Quarter
|
3rd Quarter
|
4th Quarter
|
Annual
|
||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
select an opening purchase budget item Budgeted productionBudgeted purchases costBeginning inventoryProduction needsStandard price per ounceBudgeted purchases (ounces)Standard ounces per gallonTotal DM required (ounces)Budgeted ending inventory
|
enter a number of gallons | enter a number of gallons | enter a number of gallons | enter a number of gallons | enter a number of gallons | |||||||
select an item Standard ounces per gallonBudgeted purchases (ounces)Production needsStandard price per ounceTotal DM required (ounces)Beginning inventoryBudgeted purchases costBudgeted productionBudgeted ending inventory
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces | |||
select a summarizing line for the first part Budgeted purchases costBudgeted productionTotal DM required (ounces)Standard price per ounceProduction needsBudgeted ending inventoryBeginning inventoryStandard ounces per gallonBudgeted purchases (ounces)
|
enter a total number of ounces for the first part | enter a total number of ounces for the first part | enter a total number of ounces for the first part | enter a total number of ounces for the first part | enter a total number of ounces for the first part | |||||||
select an item Standard price per ounceBudgeted purchases (ounces)Budgeted purchases costProduction needsStandard ounces per gallonBudgeted ending inventoryTotal DM required (ounces)Budgeted productionBeginning inventory
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces | |||
select a summarizing line for the second part Standard ounces per gallonStandard price per ounceBudgeted purchases costBeginning inventoryBudgeted ending inventoryProduction needsBudgeted productionTotal DM required (ounces)Budgeted purchases (ounces)
|
enter a total number of ounces for the second part | enter a total number of ounces for the second part | enter a total number of ounces for the second part | enter a total number of ounces for the second part | enter a total number of ounces for the second part | |||||||
select an item Budgeted purchases costBeginning inventoryBudgeted purchases (ounces)Total DM required (ounces)Standard price per ounceBudgeted ending inventoryBudgeted productionStandard ounces per gallonProduction needs
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces |
|
enter a number of ounces | |||
select a summarizing line for the third part Budgeted productionBudgeted ending inventoryTotal DM required (ounces)Beginning inventoryStandard ounces per gallonBudgeted purchases costStandard price per ounceBudgeted purchases (ounces)Production needs
|
enter a total number of ounces for the third part | enter a total number of ounces for the third part | enter a total number of ounces for the third part | enter a total number of ounces for the third part | enter a total number of ounces for the third part | |||||||
select an item Standard ounces per gallonTotal DM required (ounces)Beginning inventoryBudgeted ending inventoryBudgeted purchases costStandard price per ounceBudgeted purchases (ounces)Budgeted productionProduction needs
|
$enter a dollar amount rounded to 2 decimal places | |||||||||||
select a closing purchase budget item Budgeted ending inventoryStandard price per ounceStandard ounces per gallonTotal DM required (ounces)Budgeted productionBudgeted purchases (ounces)Beginning inventoryBudgeted purchases costProduction needs
|
|
|
|
|
$enter a total dollar amount |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps