Question
In: Accounting
The following selected data were taken from the accounting records of Colorado Enterprises: Month Machine Hours...
The following selected data were taken from the accounting records of Colorado Enterprises:
| Month | Machine Hours | Manufacturing Overhead | |||||
| May | 47,000 | $ | 899,000 | ||||
| June | 60,400 | 1,134,000 | |||||
| July | 70,000 | 1,295,700 | |||||
| August | 53,000 | 982,000 | |||||
Manufacturing overhead consists of three different costs; (1) machine supplies (variable), (2) property taxes (fixed), and (3) plant maintenance (semivariable). July's overhead costs were $171,500 for machine supplies, $24,200 for property taxes, and $1,100,000 for plant maintenance.
Required:
- Determine the machine supplies and property taxes for May.
- By using the high-low method, analyze Colorado’s plant maintenance cost and calculate the monthly fixed portion and the variable cost per machine hour.
- Assume that present cost behavior patterns continue into future months. Estimate the total amount of manufacturing overhead the company can expect in September if 56,400 machine hours are worked.
For all requirements, round intermediate rate calculations to 2 decimal places and all other intermediate calculations to the nearest whole dollar. Round your final answers for "Variable plant maintenance" to 2 decimal places and all other calculations to the nearest whole dollar.
machine supplies:
property taxes:
plant maintenance in may:
variable plant maintenance:
fixed plant maintenance:
manufacturing overhead:
Solutions
Expert Solution
| Req 1. | |||||||
| Total Manufacturing oh of May | 899000 | ||||||
| Less: Machine supplies (47000*2.45) | 115150 | ||||||
| Less: Property taxes | 24200 | ||||||
| Plant maintenance cost | 759650 | ||||||
| Machine Supplies in May | 115150 | ||||||
| Property taxes in may | 24200 | ||||||
| Plnt Maintenance in May | 759650 | ||||||
| Req 2. | Maintenance | MH | |||||
| At High-July | 1100000 | 70000 | |||||
| At Low-May | 759650 | 47000 | |||||
| Change | 340350 | 23000 | |||||
| VC per MH = 340350 / 23000 = | 14.8 | per mH | |||||
| Total Fixed cost: | |||||||
| Total Plant maintenance cost | 759650 | ||||||
| Less: Variable cost (14.80*47000) | 695600 | ||||||
| Fixed cost | 64050 | ||||||
| Plant maintenance | |||||||
| variable portion | 14.8 | per MH | |||||
| Fixed portion | 64050 | ||||||
| Req 3. | |||||||
| Total cost | |||||||
| variable | Fixed | ||||||
| Machine supplies | 2.45 | ||||||
| Prperty tax | 0 | 24200 | |||||
| Maintenance | 14.8 | 64050 | |||||
| Total | 17.25 | 88250 | |||||
| Total cost C(x) = 17.25X + 88250 | |||||||
| Total Estimated cost for 56400 MH = 17.25*56400 + 88250= $1061,150 | |||||||
| Req 1. | |||||||
| Total Manufacturing oh of May | 899000 | ||||||
| Less: Machine supplies (47000*2.45) | 115150 | ||||||
| Less: Property taxes | 24200 | ||||||
| Plant maintenance cost | 759650 | ||||||
| Machine Supplies in May | 115150 | ||||||
| Property taxes in may | 24200 | ||||||
| Plnt Maintenance in May | 759650 | ||||||
| Req 2. | Maintenance | MH | |||||
| At High-July | 1100000 | 70000 | |||||
| At Low-May | 759650 | 47000 | |||||
| Change | 340350 | 23000 | |||||
| VC per MH = 340350 / 23000 = | 14.8 | per mH | |||||
| Total Fixed cost: | |||||||
| Total Plant maintenance cost | 759650 | ||||||
| Less: Variable cost (14.80*47000) | 695600 | ||||||
| Fixed cost |
 ekkarill92 answered 2 years agoRelated SolutionsThe following selected data were taken from the accounting records of Manitoba Manufacturing Company. The company...The following selected data were taken from the accounting
records of Manitoba Manufacturing Company. The company uses
direct-labor hours as its cost driver for overhead costs.
Month Direct-Labor
Hours Manufacturing
Overhead
January 37,000 $
753,500
February 36,000
737,000
March 39,000
798,000
April 34,000
698,000
May 41,000 801,000
June 46,000 896,000
June’s costs consisted of machine supplies ($248,400),
depreciation ($31,000), and plant maintenance ($616,600). These
costs Exhibit the following respective behavior: variable, fixed,
and semivariable....
The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses...The following selected data were taken from the accounting
records of Metcalf Manufacturing. The company uses direct-labor
hours as its cost driver for overhead costs.
Month
Direct-Labor
Hours
Manufacturing
Overhead
January
31,000
$
695,000
February
33,000
734,000
March
43,000
893,000
April
34,000
752,750
May
38,000
796,500
June
36,000
793,500
March’s costs consisted of machine supplies ($219,300),
depreciation ($29,500), and plant maintenance ($644,200). These
costs exhibit the following respective behavior: variable, fixed,
and semivariable.
The manufacturing overhead figures presented in the...
The following selected data were taken from the accounting records of Metcalf Manufacturing. The company uses...The following selected data were taken from the accounting
records of Metcalf Manufacturing. The company uses direct-labor
hours as its cost driver for overhead costs.
Month
Direct-Labor
Hours
Manufacturing
Overhead
January
37,000
$
701,000
February
39,000
740,000
March
52,000
899,000
April
40,000
754,250
May
44,000
805,500
June
42,000
802,500
March’s costs consisted of machine supplies ($296,400),
depreciation ($32,500), and plant maintenance ($570,100). These
costs exhibit the following respective behavior: variable, fixed,
and semivariable.
The manufacturing overhead figures presented in the...
The following data were taken from the records of a company &nThe following data were taken
from the records of a company
Period 1 Period
2 Period 2
Production
30,000
38,000
27,000
Sales
30,000
27,000
38,000
Opening
Stock
-
11,000
Closing
Stock
11,000
All the above in
Kgs
The firm makes a single
product the financial details of which are as follows (based on a
normal
activity level of 30,000
kgs).
Cost per Kg (£)
Direct
material
1.50
Direct
labour
1.00
Production...
The following totals for the month of April were taken from the payroll records of Sage...The following totals for the month of April were taken from the payroll records of Sage Hill Company. Salaries $98400FICA taxes withheld 7530Income taxes withheld 20500Medical insurance deductions 3700Federal unemployment taxes 260State unemployment taxes ...
1. The following totals for the month of April were taken from the payroll records of...1. The following totals for the month of April were taken from
the payroll records of Splish Brothers Inc..
Salaries
$108000
FICA taxes withheld
8260
Income taxes withheld
23800
Medical insurance deductions
4300
Federal unemployment taxes
860
State unemployment taxes
5400
The entry to record the payment of net payroll would include
a
a. debit to Salaries and Wages Payable for $71640.
b. debit to Salaries and Wages Payable for $66240.
c. credit to Cash for $66240.
d. debit to...
The following cost and inventory data are taken from the accounting records of a Company for...The following cost and inventory data are taken from the
accounting records of a Company for the year just completed:
Costs incurred:
Direct labor cost
................................................... $140,000
Purchases of raw materials ..................................
$236,000
Manufacturing overhead ......................................
$160,000
Advertising expense .............................................
$180,000
Sales salaries
.......................................................
$100,000
Depreciation, office equipment ............................
$6,000
Inventories: Beginning the Year End the Year
Raw materials ............................ $14,000 $30,000
Work in process .......................... $20,000 $10,000
Finished goods ............................ $40,000 $70,000
Required:
1. Prepare the cost of goods...
The following cost and inventory data are taken from the accounting records of a Company for...The following cost and inventory data are taken from the
accounting records of a Company for the year just completed:
Costs incurred:
Direct labor cost
................................................... $140,000
Purchases of raw materials ..................................
$236,000
Manufacturing overhead ......................................
$160,000
Advertising expense .............................................
$180,000
Sales salaries
.......................................................
$100,000
Depreciation, office equipment ............................
$6,000
Inventories: Beginning the Year End the Year
Raw materials ............................ $14,000 $30,000
Work in process .......................... $20,000 $10,000
Finished goods ............................ $40,000 $70,000
Required:
1. Prepare the cost of goods...
The following selected account balances were taken from ABC Company's accounting records during 2018: January 1,...The following selected account balances were taken from ABC
Company's accounting records during 2018: January 1, 2018 December
31, 2018 Inventory 69,000 35,000 Accounts payable 47,000 41,000
Long-term notes payable 165,000 130,000 Income tax payable 11,000
7,000 Investments 89,000 68,000 Accounts receivable 77,000 84,000
Land 60,000 89,000 Common stock 100,000 175,000 Retained earnings
26,000 41,000 The following information was taken from ABC
Company's 2018 income statement: Sales revenue $422,000 Cost of
goods sold 361,000 Gain on sale of investments 11,000...
At the end of April, the first month of operations, the following selected data were taken...At the end of April, the first month of operations, the
following selected data were taken from the financial statements of
Shelby Crawford, an attorney:
Net income for April
$120,000
Total assets at April 30
750,000
Total liabilities at April 30
300,000
Total owner’s equity at April
30
450,000
In preparing the financial statements, adjustments for the
following data were overlooked:
•
Supplies used during April,
$2,750.
•
Unbilled fees earned at April 30,
$23,700.
•
Depreciation of equipment for...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|