Bandar Industries Berhad of Malaysia manufactures sports equipment. One of the company's products, a football helmet for the US market requires a special plastic. In the quarter that ended on June 30, the company manufactured 35,000 helmets with 22500 kilos of plastic. The plastic costs the company $ 171,000. According to the standard cost sheet, each helmet must carry 0.6 kilos of plastic, at a cost of eight units per kilo. Question 1a. Determine the cost that must have been incurred to manufacture 35,000 helmets (TOTAL STANDARD COST). Question 1b. Determine how much higher or lower the total standard cost is than the actual cost incurred (TOTAL VARIATION). Question 2. Breakdown total variation of materials between the price change of materials and variation in the amount of materials
In: Accounting
Heartland Watches Case
Imagine that you have just started working at Heartland Watches, a manufacturer of women's wristwatches, Following is the income statement of Heartland Watches for the last fiscal year.
| Sales | 40 000 000 |
| Less: Cost of Goods Sold | 22 000 000 |
| Gross Margin | 18 000 000 |
| Less: Selling and Administrative Expenses | 15 000 000 |
| Net Income | 3 000 000 |
Heartland Watches had manufactured 2 million watches, which had been sold to various department stores. At the start of 2017, Jodie Velasquez became the new president. She knew very little about accounting and manufacturing. Jodie has several questions, including inquiries about pricing of special orders.
A: To prepare better answers, you decide to convert the traditional income statement shown into a Contribution Format Income Statement. Total variable manufacturing cost was $18 million. Total variable selling and administrative expenses were $9 million. Prepare the revised Contribution Format Income Statement.
B: Complete the following table for Jodie, including your calculations:
| Total | Per Unit | |
|
Product Costs |
||
|
Variable Costs |
||
|
Gross Margin |
||
|
Contribution Margin |
C: Jodie says, "Near the end of 2016, I brought in a special order from Target for 100,000 watches at $16 each. I said I'd accept a flat $20,000 sales commission instead of the usual 6% of selling price, but my sister refused the order. She usually upheld a relatively rigid pricing policy, saying that it was bad business to accept orders that did not at least generate full manufacturing cost plus 80% of full manufacturing cost. That policy bothered me. We had idle capacity. The way I figured, our manufacturing costs would go up by 100,000 x $11 = $1,100,000, but our selling and administrative expenses would go up by only $20,000. That would mean additional operating income of 100,000 x ($16-$11) minus $20,000, or $500,000 minus $20,000, $480,000. That's too much money to give up just to maintain a general pricing policy. Was my analysis of the impact on operating income correct? If not, please show me the correct additional operating income."
Prepare a memo for Jodie summarizing your response. Answers must include supporting calculations.
D: After receiving the explanations offered in B and C, Jodie said, "Forget the Target order. I had an even bigger order from Lands' End. It was for 500,000 units and would have filled the plant completely. I told my sister I'd settle for no commission. There would have been no selling and administrative costs whatsoever because Lands' End would pay for the shipping and would not get any advertising allowances.
Lands' End offered $8.70 per unit. Our fixed manufacturing costs would have been spread over 2.5 million instead of 2 million units, Wouldn't it have been advantageous to accept the order? Our old fixed manufacturing costs were $2.00 per unit. The added volume would reduce the cost more than our loss on our variable costs per unit. Am I correct? What would have been the impact on total operating income if we had accepted the order?"
Prepare a memo for Jodie summarizing your response. Answers must include supporting calculations.
In: Accounting
High-Low Method
Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:
| Tanning | |||||
| Month | Appointments | Total Cost | |||
| January | 800 | $1,758 | |||
| February | 2,100 | $2,150 | |||
| March | 3,200 | $2,790 | |||
| April | 2,500 | $2,500 | |||
| May | 1,600 | $1,800 | |||
| June | 2,200 | $2,255 | |||
| July | 2,150 | $2,300 | |||
| August | 3,000 | $2,640 | |||
Required:
1. Which month represents the high point? The low point?
| High point | |
| Low point |
In your calculations, round per unit costs to the nearest cent.
2. Using the high-low method, compute the variable rate for tanning. Compute the fixed cost per month. Round the variable rate per tanning appointment to the nearest cent and use it in your further calculations. Round the fixed cost per month to the nearest dollar and use it in your further calculations.
| Variable rate for tanning | $ per tanning appointment |
| Fixed cost per month | $ |
3. Using the variable rate and fixed cost, what
is the cost formula for tanning services?
4. Calculate the total predicted cost of tanning services for September for 2,500 appointments using the formula found in Requirement 3. Of that total cost, how much is the total fixed cost for September? How much is the total predicted variable cost for September? If required, round the final answers to the nearest dollar.
| Total predicted cost for September | $ |
| Total fixed cost for September | $ |
| Total predicted variable cost for September | $ |
5. Which of the following statements is correct when luisa uses the high-low method to estimate the costs?
In: Accounting
Hiram’s Lakeside is a popular restaurant located on Lake Washington in Seattle. The owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. The intern, in consultation with the owner, identified three major activities and then completed the first-stage allocations of costs to the activity cost pools. The results appear below.
| Activity Cost Pool | Activity Measure | Total Cost | Total Activity | ||
| Serving a party of diners | Number of parties served | $ | 17,820 | 5,400 | parties |
| Serving a diner | Number of diners served | $ | 95,000 | 12,500 | diners |
| Serving drinks | Number of drinks ordered | $ | 36,050 | 10,300 | drinks |
The above costs include all of the costs of the restaurant except for organization-sustaining costs such as rent, property taxes, and top-management salaries.
Some costs, such as the cost of cleaning the linens that cover the restaurant's tables, vary with the number of parties served. Other costs, such as washing plates and glasses, depend on the number of diners served or the number of drinks served.
Prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. She knew that the total cost for the month (including organization-sustaining costs) was $180,000 and that 12,000 diners had been served. Therefore, the average cost per diner was $15.
Required:
1&2. According to the activity-based costing system, what is the total cost and average cost per diner for serving each of the following parties of dinners? (Round your intermediate calculations to 2 decimal places. Round your Total Cost final answers to 2 decimal places and your Average Cost final answers to 3 decimal places.)
1. A party with 3 diners and 4 drinks: total cost? avg per diner?
2. A party with 2 diners: total cost? avg per diner?
3. A party with 1 diners and 3 drinks: total cost? avg per diner?
In: Accounting
LIFO Perpetual Inventory
The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31 are as follows:
| Date | Transaction | Number of Units |
Per Unit | Total | ||||
|---|---|---|---|---|---|---|---|---|
| Jan. 1 | Inventory | 7,500 | $75.00 | $562,500 | ||||
| 10 | Purchase | 22,500 | 85.00 | 1,912,500 | ||||
| 28 | Sale | 11,250 | 150.00 | 1,687,500 | ||||
| 30 | Sale | 3,750 | 150.00 | 562,500 | ||||
| Feb. 5 | Sale | 1,500 | 150.00 | 225,000 | ||||
| 10 | Purchase | 54,000 | 87.50 | 4,725,000 | ||||
| 16 | Sale | 27,000 | 160.00 | 4,320,000 | ||||
| 28 | Sale | 25,500 | 160.00 | 4,080,000 | ||||
| Mar. 5 | Purchase | 45,000 | 89.50 | 4,027,500 | ||||
| 14 | Sale | 30,000 | 160.00 | 4,800,000 | ||||
| 25 | Purchase | 7,500 | 90.00 | 675,000 | ||||
| 30 | Sale | 26,250 | 160.00 | 4,200,000 | ||||
Required:
1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 4, using the last-in, first-out method. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Goods Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column. Round unit cost to two decimal places, if necessary.
| Midnight Supplies Schedule of Cost of Goods Sold LIFO Method For the Three Months Ended March 31 |
|||||||||
|---|---|---|---|---|---|---|---|---|---|
| Purchases | Cost of Goods Sold | Inventory | |||||||
| Date | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost | Quantity | Unit Cost | Total Cost |
| Jan. 1 | $ | $ | |||||||
| Jan. 10 | $ | $ | |||||||
| Jan. 28 | $ | $ | |||||||
| Jan. 30 | |||||||||
| Feb. 5 | |||||||||
| Feb. 10 | |||||||||
| Feb. 16 | |||||||||
| Feb. 28 | |||||||||
| Mar. 5 | |||||||||
| Mar. 14 | |||||||||
| Mar. 25 | |||||||||
| Mar. 30 | |||||||||
| Mar. 31 | Balances | $ | $ | ||||||
2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period.
| Total sales | $ |
| Total cost of goods sold | $ |
| Gross profit | $ |
3. Determine the ending inventory cost as of March 31.
$
Please answer in exact places in order for me to know what I'm checking, if its answer in different table formats, areas etc it would be wrong
thanks
In: Accounting
Organic Dairy produces an organic butter that is sold by the pound. The production of the butter begins in the Churning Department.
|
Units in beginning Work in Process (WIP) inventory |
75,000 units |
|
Units started during the month (all direct materials, including cream |
|
|
and salt, are added at the beginning of the churning process) |
1,800,000 units |
|
Units in ending Work in Process (WIP) inventory (50% of the way |
|
|
through the process) |
210,000 units |
|
Cost information is as follows: |
|
|
WIP - Churning Department balance as of January 1: |
|
|
Direct material cost included in beginning WIP balance |
292,500 |
|
Conversion cost included in beginning WIP balance |
98,600 |
|
Beginning balance, WIP, January 1 |
$391,100 |
|
Manufacturing costs incurred during January: |
|
|
Direct materials used |
$1,770,000 |
|
Direct labor |
9,000 |
|
Manufacturing overhead |
565,000 |
|
Total manufacturing costs entered into production during January |
$2,344,000 |
Requirement 1. Prepare a production cost report for
JanuaryJanuary
for the Churning Department.
Prepare a production cost report for the Churning Department, one section at a time. (For entries with a $0 balance, make sure to enter "0" in the appropriate cell(s). Round cost per equivalent unit amounts to the nearest cent, $X.XX.)
|
Organic Dairy Churning Department |
||||
|
Month Ended January 31 |
||||
|
Production Cost Report |
||||
|
Flow of |
Equivalent Units |
|||
|
Physical |
Direct |
Conversion |
||
|
Flow of Production |
Units |
Materials |
Costs |
|
|
Units to account for: |
||||
|
Beginning work in process, January 1 |
75000 |
|||
|
Plus: Started in production during January |
1800000 |
|||
|
Total physical units to account for |
1875000 |
|||
|
Units accounted for: |
||||
|
Completed and transferred out |
210000 |
|||
|
Plus: Ending work in process, January 31 |
||||
|
Total physical units accounted for |
||||
|
Total equivalent units |
||||
|
Direct |
Conversion |
|
|
Total Costs to Account for and Cost per Equivalent Unit |
Materials |
Costs |
|
Beginning work in process |
||
|
Plus: Costs added during January |
||
|
Total costs to account for |
||
|
Divided by: Total equivalent units |
||
|
Cost per equivalent unit |
|
Direct |
Conversion |
|||
|
Assignment of total costs: |
Materials |
Costs |
Total |
|
|
Completed and transferred out: |
||||
|
Equivalent units completed and transferred out |
||||
|
Multiplied by: Cost per equivalent unit |
||||
|
Costs assigned to units completed and transferred out |
|
Ending work in process: |
||||
|
Equivalent units in ending work in process, January 31 |
||||
|
Multiplied by: Cost per equivalent unit |
||||
|
Costs assigned to units in ending work in process, January 31 |
||||
|
Total costs accounted for |
Requirement 2. How much did it cost to make one pound of butter in the Churning Department? (Round all amounts to the nearest cent, $X.XX.)
|
Direct material cost |
|
|
Conversion cost |
|
|
Total cost |
Requirement 3. How much did it cost to make a partially completed pound of butter in the Churning Department? Does this make sense? Why or why not?
How much did it cost to make a partially completed pound of butter in the Churning Department? (Round all amounts to the nearest cent, $X.XX.)
|
Direct material cost |
|
|
Conversion cost |
|
|
Total cost |
Does this make sense? Why or why not?
|
No, this does not make sense |
because |
% of the |
have not yet been added. |
In: Accounting
An important application of regression analysis in accounting is in the estimation of cost. By collecting data on volume and cost and using the least squares method to develop an estimated regression equation relating volume and cost, an accountant can estimate the cost associated with a particular manufacturing volume.
In the Microsoft Excel Online file below you will find a sample of production volumes and total cost data for a manufacturing operation. Conduct a regression analysis to explore the relationship between total cost and production volume and then answer the questions that follow.
| Production Volume (units) | Total Cost ($) |
| 400 | 4100 |
| 450 | 5100 |
| 550 | 5500 |
| 600 | 6000 |
| 700 | 6500 |
| 750 | 7100 |
Compute b1 and b0 (to 1 decimal).
b1
b0
Complete the estimated regression equation (to 1 decimal).
= + x
According to this model, what is the change in cost (in dollars) for every unit produced (to 1 decimal)?
Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
r2 =
What percentage of the variation in total cost can be explained by the production volume (to 1 decimal)?
%
The company's production schedule shows 500 units must be produced next month. What is the estimated total cost for this operation (to the nearest whole number)?
$
In: Statistics and Probability
Victory Company uses weighted-average process costing to account for its production costs. Conversion cost is added evenly throughout the process. Direct materials are added at the beginning of the process. During November, the company transferred 755,000 units of product to finished goods. At the end of November, the work in process inventory consists of 199,000 units that are 50% complete with respect to conversion. Beginning inventory had $558,090 of direct materials and $128,175 of conversion cost. The direct material cost added in November is $3,734,910, and the conversion cost added is $2,435,325. Beginning work in process consisted of 67,000 units that were 100% complete with respect to direct materials and 80% complete with respect to conversion. Of the units completed, 67,000 were from beginning work in process and 688,000 units were started and completed during the period.
3. Compute the direct material cost and the
conversion cost assigned to units completed and transferred out and
ending work in process inventory. (Round "Cost per EUP" to
2 decimal places.)
|
In: Accounting
Maglie Company manufactures two video game consoles: handheld and home. The handheld consoles are smaller and less expensive than the home consoles. The company only recently began producing the home model. Since the introduction of the new product, profits have been steadily declining. Management believes that the accounting system is not accurately allocating costs to products, particularly because sales of the new product have been increasing.
Management has asked you to investigate the cost allocation problem. You find that manufacturing overhead is currently assigned to products based on their direct labor costs. For your investigation, you have data from last year. Manufacturing overhead was $1,254,000 based on production of 350,000 handheld consoles and 107,000 home consoles. Direct labor and direct materials costs were as follows:
| Handheld | Home | Total | |||||||
| Direct labor | $ | 1,158,500 | $ | 409,000 | $ | 1,567,500 | |||
| Materials | 800,000 | 657,000 | 1,457,000 | ||||||
Management has determined that overhead costs are caused by three cost drivers. These drivers and their costs for last year are as follows:
| Activity Level | ||||||
| Cost Driver | Costs Assigned | Handheld | Home | Total | ||
| Number of production runs | $ | 540,000 | 35 | 10 | 45 | |
| Quality tests performed | 522,000 | 13 | 16 | 29 | ||
| Shipping orders processed | 192,000 | 110 | 50 | 160 | ||
| Total overhead | $ | 1,254,000 | ||||
Required:
a. How much overhead will be assigned to each product if these three cost drivers are used to allocate overhead? What is the total cost per unit produced for each product? (Round "Total cost per unit" to 2 decimal places.)
|
b. How much overhead will be assigned to each product if direct labor cost is used to allocate overhead? What is the total cost per unit produced for each product? (Do not round intermediate calculations. Round "Total cost per unit" to 2 decimal places.)
|
In: Accounting
Doaktown Products manufactures fishing equipment for recreational uses. The Miramichi plant produces the company’s two versions of a special reel used for river fishing. The two models are the M-008, a basic reel, and the M-123, a new and improved version. Cost accountants at company headquarters have prepared costs for the two reels for the most recent period. The plant manager is concerned. The cost report does not coincide with her intuition about the relative costs of the two models. She has asked you to review the cost accounting and help her prepare a response to headquarters.
Manufacturing overhead is currently assigned to products based on their direct labor costs. For the most recent month, manufacturing overhead was $244,000. During that time, the company produced 10,000 units of the M-008 and 2,100 units of the M-123. The direct costs of production were as follows.
| M-008 | M-123 | Total | ||||
| Direct materials | $ | 80,000 | $ | 84,000 | $ | 164,000 |
| Direct labor | 80,000 | 42,000 | 122,000 | |||
Management determined that overhead costs are caused by three cost drivers. These drivers and their costs for last year were as follows.
| Activity Level | |||||||||
| Cost Driver | Costs | M-008 | M-123 | Total | |||||
| Number of machine-hours | $ | 64,000 | 8,000 | 2,000 | 10,000 | ||||
| Number of production runs | 80,000 | 20 | 20 | 40 | |||||
| Number of inspections | 100,000 | 30 | 20 | 50 | |||||
| Total overhead | $ | 244,000 | |||||||
Required:
a. How much overhead will be assigned to each product if these three cost drivers are used to allocate overhead? What is the total cost per unit produced for each product?
b. How much of the overhead will be assigned to each product if direct labor cost is used to allocate overhead? What is the total cost per unit produced for each product?
a. M-008 M-123
Total Overhead
Total Unit Cost
b. M-008 M-123
Total Overhead
Total Unit Cost
In: Accounting