Accounting

Sheet1
Cost Behavior Base Data:
List Your Product Name Here
ENTER YOUR INDIVIDUAL CASE NUMBER HERE 6,891.00
(THIS IS IN YOUR GRADEBOOK UNDER THE COLUMN “CASE NUMBER”)
First Name Last Name
Enter Your Name Here
Units Manufactured 100
Direct Materials (in $’s):
Total Cost for Your Direct Material Number 1 $ 6,891
Total Cost for Your Direct Material Number 2 $ 4,135
Total Cost for Your Direct Material Number 3 $ 2,756
Total Direct Materials (in $’s) $ 13,782
Direct Labor (in $’s) $ 11,891
Variable Factory Overhead (in $’s)
Total Cost for Your F/O Number 1 $ 13,782
Total Cost for Your F/O Number 2 $ 16,891
Total Factory Overhead (in $’s) $ 30,673
Cost of Goods Manufactured $ 56,346
(No Beg or End D/M or WIP Inventories)
Sales Price Per Unit $ 984
Units Sold 100
Total Sales in $’s $ 98,400
Fixed Cost $ 25,000
WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT:
Record your answer here
2) What is your Product’s Contribution Margin per unit?
Record your answer here
3) What is your Product’s Contribution Margin percent?
Record your answer here
4) How Many Units Would Have to be Sold to break even?
Record your answer here
5) How Many Units Would Have to be Sold to Yield a Target Operating Income of $30,000?
Record your answer here
6) USING YOUR OPERATING INCOME IN CELL C38, What is your Product’s Planned Net Income Assuming a Tax Rate of 30%?
Record your answer here
Case Part 2 Grading: Possible Points Earned Points
2 points for each correct answer 12
1 point for use of excel formulas to support answers 6
Total points for case part 2 18 0
&CACC 311 Interactive Case Part 2 – Cost Behavior Blank File
&C&”Arial,Bold”&12Page &P of &N
Sheet2
Sheet3