OBJECTIVE The purpose of this assignment is prepare certain budgets using Excel
ID: 2526145 • Letter: O
Question
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?Explanation / Answer
Answer 3:
67050
Answer 4:
Sales budget Particulars October November December Total Sales 40000 43000 50000 133000 selling price per gallon 7 7 7 7 sales 280000 301000 350000 931000 Production budget Sales 40000 43000 50000 133000 add closing stock 4300 5000 5100 14400 less opening stock 4000 4300 5000 13300 production 40300 43700 50100 134100 direct labour budget production 40300 43700 50100 134100 directlabour per gallon 0.5 0.5 0.5 0.5 Direct labour hours 20150 21850 2505067050
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.