Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Patient Care Audit Criteria

Authors: Jean Gayton Carroll

1st Edition

0870943928, 978-0870943928

More Books

Students also viewed these Accounting questions