Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel Spreadsheet due in a couple days! Thanks for the help. Chapter 22 Week One Assignment - Using Excel to Prepare Budgets Using the information
Excel Spreadsheet due in a couple days! Thanks for the help.
Chapter 22 Week One Assignment - Using Excel to Prepare Budgets Using the information below, complete the required elements using Excel per the instructions: Heartland Inc. makes specialty apple cider sold in one-gallon containers. Sales units for the next four months are expected to be: Additional information for the company is as follows: The average selling price is $6 per gallon. Heartland's policy is to have 10% of the next month's sales in ending inventory. On September 30, it is expected that 5,000 gallons of cider will be on hand. Each gallon of cider requires 0.25 direct labor hours. The average wage per hour is $8. -For the fourth quarter, by month and total (October -December), prepare a Sales Budget, a Production Budget, and a Direct Labor Budget in good form using Excel formulas whenever possible. Use Times New Roman 11. -Set up a data table either in a separate worksheet tab or at the beginning of your Excel worksheet with the expected sales in units and any other facts you will need for your formulas. -The Sales Budget, Production Budget and Direct Labor Budget should be completed on one worksheet and must be clearly labeled and properly formatted. Formatting includes the use of dollar signs where necessary and lines to clearly delineate sub-totals and totals. Use Exhibits 22-5, 22-6 and 22-8 in your text as examples. -Make sure your spreadsheets are also formatted for easy printing by me. If you don't know how to do this, go to the Page Layout tab and select Print Area. -Include your name on your document. -Grading will be based on the calculation of correct budgeted amounts (50%) as well as the use of Excel formulas and formatting (50%). Save your file as: Last Name.First Initial.Excel2017. For example, my assignment would be saved as Mansouri.N.Excel2017.xlsx. Upload to Blackboard - do not upload a .jpg or .png fileStep 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