question archive Sheet1 Cost Behavior Base Data: List Your Product Name Here ENTER YOUR INDIVIDUAL CASE NUMBER HERE 6,891
Sheet1 Cost Behavior Base Data: List Your Product Name Here ENTER YOUR INDIVIDUAL CASE NUMBER HERE 6,891
Subject:BusinessPrice: Bought3
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
