Cover-to-Cover Company is a manufacturer of shelving for books. The company has compiled the following cost data, and wants your help in determining the cost behavior. After reviewing the data, complete requirements (1) and (2) that follow.
|
Units |
Total |
Total |
Total Machine |
|---|---|---|---|
|
Produced |
Lumber Cost |
Utilities Cost |
Depreciation Cost |
|
4,000 shelves |
$48,000 |
$5,600 |
$130,000 |
|
8,000 shelves |
$96,000 |
$10,200 |
$130,000 |
|
16,000 shelves |
$192,000 |
$19,400 |
$130,000 |
|
20,000 shelves |
$240,000 |
$24,000 |
$130,000 |
1. Determine whether the costs in the table are variable, fixed, mixed, or none of these.
|
Variable Cost |
Fixed Cost |
Mixed Cost |
None of these |
||
|---|---|---|---|---|---|
|
Lumber |
|||||
|
Utilities |
|||||
|
Depreciation |
2. For each cost, determine the fixed portion of the cost, and the per-unit variable cost. If there is no amount or an amount is zero, enter "0". Recall that, for N= Number of Units Produced, Total Costs = (Variable Cost Per Unit x N) + Fixed Cost. Complete the following table with your answers.
Cost Fixed Portion of Cost Variable Portion of Cost (per Unit)
Lumber $ $
Utilities $ $
Depreciation $ $
Biblio Files Company is the chief competitor of Cover-to-Cover Company in the bookshelf business. Biblio Files is analyzing its manufacturing costs, and has compiled the following data for the first six months of the year. After reviewing the data, answer questions (1) through (3) that follow.
|
Month |
Number of Units Produced |
Total Cost |
|---|---|---|
|
January |
4,360 |
$65,600 |
|
February |
225 |
$6,250 |
|
March |
1,000 |
$15,000 |
|
April |
5,475 |
$111,250 |
|
May |
1,750 |
$32,500 |
|
June |
3,015 |
$48,000 |
1. From the data previously provided, help Biblio Files Company estimate the fixed and variable portions of its total costs using the High-Low Method. Recall that Total Costs = (Variable Cost Per Unit x Units Produced) + Fixed Cost. Complete the following table.
|
Total Fixed Cost |
Variable Cost per Unit |
2. With your Total Fixed Cost and Variable Cost per Unit from the High-Low Method, compute the total cost for the following values of N (Number of Units Produced).
|
Number of Units Produced |
Total Costs |
|
3,500 |
|
|
4,360 |
|
|
5,025 |
3. Why does the total cost computed for 4,360 units not match the data for January in the table at the top of this panel?
The High-Low method gives a formula for the estimated total cost and may not match levels of production other than the highest and lowest.
The High-Low method only gives accurate data when fixed costs are zero.
The High-Low method gives accurate data only for levels of production outside the relevant range.
The High-Low method is accurate only for months in which production is at full capacity.
In: Accounting
Which of the following best states why why in the short run a firm may decide to continue to produce, even with economic losses? Select one:
a. Price is greater than average variable cost but less tha average total cost
. b. Total revenue is greater than total variable cost but less than total cost.
c. All of the above are reasons for continuing production.
d. One of the above is incorrect. e. Economic losses areless than fixed cost.
In: Economics
Wrap up question 1: You hold a “Top” piece of charged tape near an uncharged soda can. Describe the behavior of the tape. Would the behavior be different if you used a “Bottom” piece of tape instead? Explain.
Wrap up question 2: Suppose there exists a third type of charge in addition to the two types we associate with glass and plastic. Call this third type X charge. What experiment(s) could you use to test whether an object has X charge? State clearly how the outcome(s) of the experiment(s) would be interpreted.
Wrap up question 3: A positively charged electroscope has separated leaves. Describe what will happen if you bring a negatively charged rod near, but not touching, the top of the electroscope.
In: Physics
The following table gives the map coordinates and the shipping loads for a set of cities that we wish to connect through a central hub.
|
City |
Map Coordinates
(x,y) |
Shipping Load |
|
|
A |
(6,10) |
4 |
|
|
B |
(6,7) |
9 |
|
|
C |
(3,9) |
16 |
|
|
D |
(7,4) |
5 |
|
|
E |
(6,9) |
15 |
|
|
F |
(4,2) |
10 |
|
|
G |
(2,7) |
6 |
|
a) For the location of the proposed new central hub, the coordinates should be near:
x = ____ (round your response to two decimal places).
y = _____ (round your response to two decimal places).
b) If the shipments from city A double, for the location of the proposed new central hub, the coordinates should be near:
x = ___ (round your response to two decimal places).
y = ___ (round your response to two decimal places).
In: Operations Management
Problem 18-2A Scatter diagram and cost behavior estimation LO P1
[The following information applies to the questions displayed below.]
Alden Co.’s monthly unit sales and total cost data for its
operating activities of the past year follow. Management wants to
use these data to predict future fixed and variable costs.
| Month | Units Sold | Total Cost | Month | Units Sold | Total Cost | |||||||||||||||
| 1 | 322,000 | $ | 159,500 | 7 | 358,000 | $ | 263,504 | |||||||||||||
| 2 | 167,000 | 103,250 | 8 | 272,000 | 153,750 | |||||||||||||||
| 3 | 267,000 | 207,600 | 9 | 75,600 | 63,000 | |||||||||||||||
| 4 | 207,000 | 102,000 | 10 | 152,000 | 132,625 | |||||||||||||||
| 5 | 292,000 | 203,500 | 11 | 96,000 | 96,000 | |||||||||||||||
| 6 | 192,000 | 114,000 | 12 | 102,000 | 79,650 | |||||||||||||||
Problem 18-2A Part 2
2. Estimate both the variable costs per unit and the total monthly fixed costs using the high-low method. (Do not round intermediate calculations.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
In the past, Best Car has used direct labor hours as a basis of allocating overhead. Now, that they are looking to experiment with ABC, they have identified the following activities, activity cost pools and cost drivers in its manufacturing overhead as shown in the ABC schedule. The cost driver quantity per product line is 80% of total cost driver quantity for product A; and 20% for product B.
Required:
1) Complete the schedule below
2) Compute overhead for model A
3) Compute overhead for model B
| Activity | Activity cost pool | Cost driver | Cost driver qty | Pool rate | Product Line | Cost driver quantity per product line | Activity cost per product line | Product Line production Volume | Activity cost per unit of product |
| 1. Purchasing | $ 30,000.00 | Purchase orders | 1,000 | A | Product A 10,000.00 | ||||
| B |
Product B 8,000.00 |
||||||||
| Total | Total 18,000.00 | ||||||||
| 2. Machine related | $ 2,000,000.00 | Machine hours | 250,000 | A | |||||
| B | |||||||||
| Total | |||||||||
| 3. Set up | $ 124,000.00 | Production runs | 120,000 | A | |||||
| B | |||||||||
| Total | |||||||||
| 4. Quality Assurance | $ 55,000.00 | Inspection Hours | 5,000 | A | |||||
| B | |||||||||
| Total | |||||||||
| 5. Facility | $ 2,400,000.00 | Machine hours | 250,000 | A | |||||
| B | |||||||||
| Total | |||||||||
| Total | $ 4,609,000.00 | ||||||||
| Overhead A | |||||||||
| Overhead B |
In: Accounting
Profit and Loss Worksheet - (Figure %’s to 2 decimal places)
Cost of sales
Open and use the chart below for the Cost of Sales Quiz. 7 questions A – G
Cost of sales ÷ sales = cost of sale %
Sales × cost of sale % = cost of sales
Cost of sales ÷ Cost % = Sales
|
Cost of food sales 256,820.32 |
Food Sales 802,562.50 |
Cost of Food % (A) |
|
Cost of Beer Sales (B) |
Beer Sales 32,505.00 |
Cost of Beer % 27.50 % |
|
Cost of Wine Sales 12,465.00 |
Wine Sales (C) |
Cost of Wine % 28.5 % |
|
Cost of Liquor Sales 8,121.13 |
Liquor Sales 36,914.25 |
Cost of Liquor % (D) |
|
Total Cost of Goods (ADD Food,beer,wine, and liquor costs) (E) |
Total Sales (ADD food,beer,wine and liquor sales) (F) |
Total Cost of Goods Sold % (figure Total cost of Goods) (G) |
A.
B.
C.
D.
E.
F.
G.
In: Operations Management
In: Economics
The following information is available for a company’s
maintenance cost over the last seven months.
| Month | Maintenance Hours | Maintenance Cost | ||||
| June | 10 | $ | 3,950 | |||
| July | 19 | 5,390 | ||||
| August | 11 | 4,110 | ||||
| September | 14 | 4,590 | ||||
| October | 20 | 5,550 | ||||
| November | 23 | 6,030 | ||||
| December | 5 | 3,150 | ||||
Using the high-low method, estimate both the fixed and variable
components of its maintenance cost.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
The following information is available for a company’s
maintenance cost over the last seven months.
| Month | Maintenance Hours | Maintenance Cost | ||||
| June | 9 | $ | 3,950 | |||
| July | 18 | 5,750 | ||||
| August | 12 | 4,550 | ||||
| September | 15 | 5,150 | ||||
| October | 21 | 6,350 | ||||
| November | 24 | 6,950 | ||||
| December | 6 | 3,350 | ||||
Using the high-low method, estimate both the fixed and variable components of its maintenance cost.
High- Low method calculation of variable cost per maintenance hour
__________________ ____________________ ____________ _______________ __________0
_________________ ____________________ _______________
Total cost at the high point $_____________________
Variable costs at the high point:
Volume at the high point: ________________________
Variable cost per maintenance hour ____________________
Total variable costs at the high point __________________________
Total fixed costs ________________________
Total cost at the low point _________________
Variable costs at the low point: _________________
Volume at the low point: _______________
Variable cost per maintenance hour ____________
Total variable costs at the low point
Total fixed costs
In: Finance