Answered step by step
Verified Expert Solution
Question
1 Approved Answer
OBJECTIVE The purpose of this assignment is prepare certain budgets using Excel in an efficient and effective manner.-- DATA SET leyland Inc. makes specialty apple
OBJECTIVE The purpose of this assignment is prepare certain budgets using Excel in an efficient and effective manner.-- DATA SET leyland Inc. makes specialty apple cider sold in one-gallon containers. Sales units and additional information required for budgeting are as follows: Data Required for Budget Preparation 2 October November December 4 Expected Sales in Gallons 40,000 43,000 50,000 6 Selling price 7 per gallon 8 Inventory balance requirement 9 Sept 30th inventory 10 December 30th inventory 10% of next month's sales units ,000 gallons ,100 gallons 0.5 12 DLH per gallon 13 14 W 15 10 per DLH REQUIREMENTS. 1. This is an individual assignment. Each student is responsible for submitting his/her own work. 2. Create an Excel file Label the first worksheet tab as DESCRIPTION. In this sheet, enter your name, the date and a title that briefly describes the assignments Label the second sheet BUDGET and enter the information as shown above (data table) a. b. 3. In the BUDGET sheet, prepare a sales budget, a production budget, and a direct labor budget for each month and for the total 4th quarter in good form. Prepare columns for each month and one for the quarter Hints: There should be no direct inputs in the budget schedules. Every cell of the budget should be a reference to the data table or a calculation of other cells in the spreadsheet. 4. Answer the following question and insert your response in a text box below your budgets If Joyland Inc. revised its November sales forecast from 43,000 gallons to 47,000 gallons, what would the total sales dollars and direct labor hours be for the quarter? What management decisions would be impacted by the increase in gallons sold? OBJECTIVE The purpose of this assignment is prepare certain budgets using Excel in an efficient and effective manner.-- DATA SET leyland Inc. makes specialty apple cider sold in one-gallon containers. Sales units and additional information required for budgeting are as follows: Data Required for Budget Preparation 2 October November December 4 Expected Sales in Gallons 40,000 43,000 50,000 6 Selling price 7 per gallon 8 Inventory balance requirement 9 Sept 30th inventory 10 December 30th inventory 10% of next month's sales units ,000 gallons ,100 gallons 0.5 12 DLH per gallon 13 14 W 15 10 per DLH REQUIREMENTS. 1. This is an individual assignment. Each student is responsible for submitting his/her own work. 2. Create an Excel file Label the first worksheet tab as DESCRIPTION. In this sheet, enter your name, the date and a title that briefly describes the assignments Label the second sheet BUDGET and enter the information as shown above (data table) a. b. 3. In the BUDGET sheet, prepare a sales budget, a production budget, and a direct labor budget for each month and for the total 4th quarter in good form. Prepare columns for each month and one for the quarter Hints: There should be no direct inputs in the budget schedules. Every cell of the budget should be a reference to the data table or a calculation of other cells in the spreadsheet. 4. Answer the following question and insert your response in a text box below your budgets If Joyland Inc. revised its November sales forecast from 43,000 gallons to 47,000 gallons, what would the total sales dollars and direct labor hours be for the quarter? What management decisions would be impacted by the increase in gallons sold
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started