Posted: February 26th, 2023

# I need help with an account excel spread sheet

can someone help me with how to make an excel spreadsheet for an accounting class? using the provided template

Assignment #2– Master Budget Project

Due Sunday Week 6

100 Points –Excel Worksheet

1. Complete problem P9-63A from the textbook using the attached template. The
template must be used to complete this project (no points will be given if
submitted in a different format or file).

2. You must show your work. This is done by inputting formulas/calculations directly
into the cells where necessary. If formulas/calculations are not used, points may
be deducted (a max of 10 points) at the discretion of the instructor.

3. The blue shaded areas are for data input.
4. Look out for a red triangle in the upper right-hand corner of a cell. If you hover

over the cell you will see a hint or instructions for that cell.
5. To the right of the budget schedules is the grading area that is being calculated

as you input information. Please use this area to see where any mistakes are

6. The template begins with the Sales Budget. This is not a required schedule but is
included as you will need to reference this information to complete other
schedules.

7. Please make sure to put your name at the top of the sheet AND also save the file

8. With the exception of the Budgeted Manufacturing Cost per Unit schedule, round
all numbers to the nearest whole dollar.

a. The textbook and PowerPoint slides for Chapter 9 include detailed

examples of how to complete the required schedules
b. In My Accounting Lab, on the left side menu, click ‘Multimedia Library.’

Select ‘Chapter 9’, click ‘Select All’, and click ‘Find Now.’ There is a Try it
in Excel video that you may find useful

c. You can search Youtube for videos explaining how to input
formulas/calculations into Excel

<h

2

>Master Budget P9-57

00

0

0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter

INCORRECT
0

INCORRECT
0

0

PRODUCTION BUDGET:

INCORRECT
0

Jan
Feb
Mar
Quarter

INCORRECT
0

Budgeted unit sales

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter
Apr

INCORRECT
0

TOTAL
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter

INCORRECT
0

INCORRECT
0

TOTAL
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter

INCORRECT
0

TOTAL
0

996
INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter

INCORRECT
0

3

INCORRECT
0

TOTAL
0

Total cash payments

INCORRECT
0

INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter

INCORRECT
0

TOTAL
0

Total cash payments

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

Jan
Feb
Mar
Quarter

TOTAL
0

CASH BUDGET

INCORRECT
0

INCORRECT
0

9000
INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

INCORRECT
0

4873
INCORRECT
0

TOTAL
0

MANUFACTURING COST PER UNIT

Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter

4
INCORRECT
0

INCORRECT
0

INCORRECT
0

CORRECT
2

INCORRECT
0

TOTAL
2

INCOME STATEMENT

INCORRECT
0

INCORRECT
0

INCORRECT
0

Operating Expenses

30100
INCORRECT
0

INCORRECT
0

INCORRECT
0

330
INCORRECT
0

Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter

Charms: Hint: This is not a sum of the quarter. It is asking for the balance at the end of the quarter

INCORRECT
0

INCORRECT
0

TOTAL
0

GRAND TOTAL

2