Question
The following problem is an example of MIXED COSTS : This costs contains both variable and fixed components. Also known semi-variables. The linear equation Y
The following problem is an example of MIXED COSTS : This costs contains both variable and fixed components. Also known semi-variables. The linear equation Y = A + BX (page 38 in the book) show the exhibit 2-5 help the manager to separate each cost in fixed and variable.
1. The WESTERN HOTEL has accumulated records of the total electrical costs of the hotel and number of occupancy days over the last year. An occupancy-day represents a room rented out for one day. The hotels business is highly seasonal, with peaks occurring during the ski season and in the summer.
| Month - 2016 | Occupancy-days | Electrical costs |
| Jan | 2,604 | $ 6,257 |
| Feb | 2,856 | 6,550 |
| March | 3,534 | 7,986 |
| April | 1,440 | 4,022 |
| May | 540 | 2,289 |
| June | 1,116 | 3,591 |
| July | 3,162 | 7,264 |
| Aug | 3,608 | 8,111 |
| Sep | 1,260 | ? |
| Oct | 1,186 | ? |
| Nov | 1,080 | ? |
| Dec | 2,046 | ? |
REQUIRED
- Using the HIGH-LOW METHOD, estimate the FIXED COSTS of electricity per month and the VARIABLE COST of electricity per occupancy-day from September to December.
HINT: The cost driver is Occupancy days (which causes the cost to occur) Determine the regression formula to be able to project costs from September to December and then the first 4 months of next year.
| Cost Driver | Occupancy days | Electrical costs |
|
| High activity level ( cost driver) | 3,608 | $ 8,111 |
|
| Low activity level ( cost driver) | 540 | 2,289 |
|
| Change | 3,068 | $ 5,822 |
|
A: Variable Cost Element = Change in Cost $ = 5,822 / 3,068 = 1.90 per day op
change of activity
B Fixed Cost Element = Total cost Variable cost element
$ 8,111 ( 1.90 x 3,608 Occup days)
8.111 6,855 = 1,256 , fixed cost
Then the equation is : Y = A + BX
Y = 1,256 + 1.90(X)
Note: To complete the projections from September to December, all you have to do is replace the X with the COST DRIVER OF EACH MONTH and you get the cost for each month of electricity and you can project the months of next year.
- Using the cost formula and projected the electrical costs for the followings months: year 2017
| Month - 2017 | Occupancy days | Electrical costs |
| Jan 2017 | 3,500 | $ ? |
| Feb | 4,050 | ? |
| March | 4,800 | ? |
| April | 2,500 | ? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Cost Accounting A Managerial Emphasis
Authors: Charles T. Horngren, Srikant M. Datar, Madhav V. Rajan
15th edition
978-0133428858, 133428850, 133428702, 978-0133428704
