Instructions for the Microsoft Excel Templates
Detail and information on Excel is contained within the manual.
Striking the "F1" key or following the path "Windows>Excel Help" will invoke the Office Assistant
and bring up one of several help menus.
Type your name into the cell "D2". This will be copied by formula to the rest of the pages as required.
Type the date into cell "I2". This will be copied by formula to the rest of the pages as required.
Type the instructor's name into cell "D3". This will be copied by formula to the rest of the pages as required.
Type the course identifier into cell "I3". This will be copied by formula to the rest of the pages as required.
The problem is identified for you in cell "B7".
In "DATE" cells enter the date in any of several formats and Excel will format it correctly.
These can include 01/01/12, 01/01/2012, and Jan 01, 2012.
If more than one page is preformatted into the problem, page breaks are preset and formulas are
set to copy the header into the remaining pages.
Place the proper account title in the cell where the word "ACCOUNT" appears on the template.
In cells containing "AMOUNT" you can enter a value such as 92.21 or 1002.82. Do not enter values with commas
such as 59,879.45. Excel does not like the comma.
In most exercises and problems, the text is structured in a manner to put the amounts in cells so that "look-to
(=A1) type formulas can be used.
A formula may be placed in many of the cells containing "AMOUNT."
In cells that contain "NUMBER", the value indicates that something like number of parts, number of gallons, or
number of units sold should be entered.
Write a formula into cells where the word "FORMULA" appears. In these cells, an amount calculated outside of
Place the explanation for the entry in the cell where "EXPLANATION" or "TEXT ANSWER HERE." appears on the template.
Insert the account number where "ACCT #" appears on the template during posting.
Insert the journal reference where "JOURN #" appears on the template during posting.
Insert the title in the cell where "TITLE" appears on the template.
The print area is defined to fit onto 8 1/2" X 11" sheets in portrait or landscape mode as required.
The gray filled cells define the perimeter of the problem and the print area.
The problem is formatted for whole dollars with comma separations (no cents) except where required.
The display may have "Freeze Pane" invoked so column titles remain visible during data entry.
Negative values may be shown as ($400) vice -$400.
pears on the template.
Managerial Accounting, 4th Edition by James Jiambalvo
Solving Managerial Accounting Problems Using Microsoft Excel
for Windows Templates by Rex A Schildhouse
EXERCISE E4-12 - CVP Analysis, Profit Equation
Clyde’s Marina has estimated that fixed costs per month are $300,000 and variable cost
per dollar of sales is $0.40
a. What is the break-even point per month in sales?
Enter text answer here.
Selling price: (Relational) Amount
Variable cost: (Relational) Amount
Contribution Margin: (Relational) Formula
Fixed costs: Amount ÷ Amount = Formula
b. What level of sales is needed for a monthly profit of $60,000 ?
( Amount + Amount ) ÷ Amount = Formula
c. For the month of July, the marina anticipates sales of $1,000,000 What is the expected level of
( Amount * Amount ) - Amount = Formula
1cdbf170-2a31-41fa-90de-4efda92fbccc.xlsx, Exercise E4-12, Page 4 of 5, 2/25/2012, 11:56 AM
1cdbf170-2a31-41fa-90de-4efda92fbccc.xlsx, Exercise E4-12, Page 5 of 5, 2/25/2012, 11:56 AM