Reference no: EM131812009
Scenario 1
The BlueDenim Company makes blue jeans. The company's controller wants to calculate the fixed and variable costs associated with electricity used in the factory. Data for the past 8 months were collected:
| Month |
Electricity Cost |
Machine Hours |
| January |
$3,255 |
460 |
| February |
3,485 |
500 |
| March |
4,100 |
600 |
| April |
3,300 |
470 |
| May |
3,312 |
470 |
| June |
2,575 |
350 |
| July |
3,910 |
570 |
| August |
4,200 |
590 |
Open the attached spreadsheet. Complete question parts a - c on the spreadsheet. Be sure to use formulas in the gray shaded cells. The results of the formulas will be needed to perform the analysis required in the CengageNOW problem. Compare your spreadsheet answers for question parts a - c to the following Cornerstones to confirm that you have entered your formulas correctly.
Find the high and low number of machine hours. Calculate variable rate of electricity per machine hour, the fixed cost, and construct the cost formula. (Cornerstone 3.2)
Assume that 550 machine hours are budgeted for the month of October. Use the previous cost formula in part a to calculate the total variable electricity cost for October and total electricity cost for October. (Cornerstone 3.3)
Assume 6,500 machine hours are budgeted for the coming year. Use the previous cost formula in question part a to calculate the total variable electricity cost for the year, total fixed electricity cost for the year, and total electricity cost for the coming year. (Cornerstone 3.4)
Scenario 2
The executive team at BlueDenim has requested that you perform an analysis of their factory. In some cases, you will need to rearrange the equations used in question parts a, b, or c to perform the requested analysis. Respond to question parts d - g in this CengageNOW problem regarding the analysis.
Using the same equations you created above in question part b, determine the costs below if the company expects to have 580 machine hours this month.
1. Total variable costs: $
2. Total electricity costs: $
Using the equations you created in above in question part b, determine the costs below if the company expects to use 400 machine hours this month.
1. Total variable costs: $
2. Total electricity costs: $
What is the relevant low and high range for machine hours for the cost formula created in question part a?
and machine hours
Using the equation you created above in question part b, what would the total electricity cost if a new plan from the electricity company executive team reduces the fixed cost to $380 and number of machine hours to 400 hours?
|
Corporation manufacturing overhead cost for the year
: The Corporation had estimated that it would work 44,000 direct labor-hours during the year and incur $836,000 of manufacturing overhead cost.
|
|
What is the markup on variable costs needed to break even
: Faulkner Corporation has the following budgeted costs for 20,000 units: What is the markup on variable costs needed to break even
|
|
Woolen textile had an annual turnover
: The Woolen textile had an annual turnover of INR 8 billion with poor profitability." what does INR stand for and what does it mean in plain English?
|
|
How you would investigate and report on the occurrence of tb
: Using the epidemiological foundation concepts of person time and place, evaluate how you would investigate and report on the occurrence of TB in your workplace.
|
|
Calculate the fixed and variable costs
: The BlueDenim Company makes blue jeans. The company's controller wants to calculate the fixed and variable costs associated with electricity
|
|
What will be each partner managerial role in the restaurant
: Decide what each partner's managerial role in the restaurant will be. For example, who will be responsible for the necessary departments and specific activities
|
|
Explain a basic understanding of marketing
: Everyone should have a basic understanding of marketing. It can be used to market products, services, people, companies, charities, and ideas.
|
|
Explain why transfer prices based on total actual costs
: Explain why transfer prices based on total actual costs are not appropriate as the basis for divisional performance measurement
|
|
Journalize the necessary entries based on the reconciliation
: A customer's check for $320.10 from Nancy Su was returned by the bank because of insufficient funds. Journalize necessary entries based on the reconciliation
|