Question: please include the cell info in the explanation. please and thank you. 2. Create an Excel file. a. Label the first worksheet tab as DESCRIPTION.

please include the cell info in the explanation.
please and thank you.  please include the cell info in the explanation. please and thank
you. 2. Create an Excel file. a. Label the first worksheet tab
as DESCRIPTION. In this sheet, enter your name, the date, and a

2. Create an Excel file. a. Label the first worksheet tab as DESCRIPTION. In this sheet, enter your name, the date, and a title that briefly describes the assignments b. Label the second sheet BUDGET and enter the information as shown above (data table). 3. In the BUDGET sheet, create a sales budget, a production budget, and a direct labor budget for each month provided and for the total 3rd quarter. Prepare columns for each month and one for the quarter. Your spreadsheet should be prepared in good form with proper formatting (commas, underlines, headings) Hints: There should be no direct inputs in the budget schedules. Every cell of the budget should be a reference to the data table (i.e. = cell) or a calculation of other cells in the spreadsheet. 4. Answer the following question by inserting your response in a text box below your budgets in the Excel spreadsheet. If NBC. revised its July sales forecast from 45,000 to 58,000 units, what would the total sales dollars and direct labor hours be for the quarter? Specifically identify at least two management decisions that would be impacted by the increase in units sold

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!