Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show formulas!! OBJECTIVE The purpose of this assignment is prepare certain budgets using Excel in an efficient and effective manner. DATA SET NBC produces

please show formulas!! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
OBJECTIVE The purpose of this assignment is prepare certain budgets using Excel in an efficient and effective manner. DATA SET NBC produces video equipment. The production manager is completing the budget process for the third quarter of 2022. Sales units and additional information for the 3rd quarter are as follows: REQUIREMENTS 1. This is an individual assignment. Each student is responsible for submitting his/her own work. Use of Chegg or other online sites is forbidden. 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. Your answer should be complete and be comprehensible to someone who does not have access to the assignment instructions. Hint: To insert a textbox in Excel, click on the Toolbar labeled Insert, then click on the Text dropdown menu. (There should be a rectangular icon with a slanted " A " in the center.) Select textbox, and then place it in the body of the worksheet. Follow the attached instructions to create and complete the Excel assignment. In this assignment you will create the following budgets: - Sales - Production - Direct Labor In question 4 of the assignment, be sure to change July sales to 58,000 units

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

Auditing Oracle E Business Suite Common Issues

Authors: Jeffrey T. Hare

1st Edition

1329529766, 978-1329529762

Students also viewed these Accounting questions

Question

Identify the types of informal reports.

Answered: 1 week ago

Question

Write messages that are used for the various stages of collection.

Answered: 1 week ago