Kingsport Containers Company makes a single product that is subject to wide seasonal variations in demand. The company uses a job-order costing system and computes plantwide predetermined overhead rates on a quarterly basis using the number of units to be produced as the allocation base. Its estimated costs, by quarter, for the coming year are given below:

Management finds the variation in quarterly unit product costs to be confusing and difficult to work with. It has been suggested that the problem lies with manufacturing overhead because it is the largest element of total manufacturing cost. Accordingly, you have been asked to find a more appropriate way of assigning manufacturing overhead cost to units of product.

Required:

1. Assuming the estimated variable manufacturing overhead cost per unit is $0.30, what must be the estimated total fixed manufacturing overhead cost per quarter?

2. Assuming the assumptions about cost behavior from the first three quarters hold constant, what is the estimated unit product cost for the fourth quarter?

3. What is causing the estimated unit product cost to fluctuate from one quarter to the next?

4. Assuming the company computes one predetermined overhead rate for the year rather than computing quarterly overhead rates, calculate the unit product cost for all units produced during the year.

Kingsport Containers Company makes a single product that is subject to wide seasonal variations in demand. The company uses a job-order costing system and computes plantwide predetermined overhead rates on a quarterly basis using the number of units to be produced as the allocation base. Its estimated costs, by quarter, for the coming year are given below:

Management finds the variation in quarterly unit product costs to be confusing and difficult to work with. It has been suggested that the problem lies with manufacturing overhead because it is the largest element of total manufacturing cost. Accordingly, you have been asked to find a more appropriate way of assigning manufacturing overhead cost to units of product.

Required:

1. Assuming the estimated variable manufacturing overhead cost per unit is $0.40, what must be the estimated total fixed manufacturing overhead cost per quarter?

2. Assuming the assumptions about cost behavior from the first three quarters hold constant, what is the estimated unit product cost for the fourth quarter?

3. What is causing the estimated unit product cost to fluctuate from one quarter to the next?

4. Assuming the company computes one predetermined overhead rate for the year rather than computing quarterly overhead rates, calculate the unit product cost for all units produced during the year.

Luther Processing Company uses a weighted-average process costing system and manufactures a single product—a premium rug shampoo and cleaner. The company has just completed the manufacturing activity for the month of October. A partially completed production cost report for the month of October for the mixing department is shown below.

Calculate equivalent units and complete production cost report.

**********

Equivalent Units

Quantities
Physical Units

Materials

Conversion Costs

Units to be accounted for

 Work in process, October 1 (all materials, 70% conversion costs)
20,000

 Started into production
160,000

Total units
180,000

Units accounted for

 Transferred out
130,000
?
?

 Work in process, October 31 (60% materials, 40% conversion costs)
50,000
?
?

  Total units accounted for
180,000
?
?

Costs
Materials

Conversion Costs

Total

Unit costs

 Costs in October
$240,000

$105,000

$345,000

 Equivalent units
?

?

 Unit costs
$ ?
+
$ ?
=
$ ?

Costs to be accounted for

 Work in process, October 1

$ 30,000

 Started into production

315,000

  Total costs

$345,000

Cost Reconciliation Schedule

Costs accounted for

 Transferred out

$ ?

 Work in process, October 31

  Materials

?

  Conversion costs

?

?

   Total costs

$ ?

Instructions

a. Prepare a schedule that shows how the equivalent units were calculated so that you can complete the “Quantities: Units accounted for” equivalent units section of the production cost report, and calculate October unit costs.

Materials $1.50

b. Complete the “Cost Reconciliation Schedule” part of the production cost report above.

Transferred out $286,000Work in process $59,000 (Weygandt, 12/2017, pp. 161-162) Weygandt, J. J., Kimmel, P. D., Kieso, D. E., Aly, I. M. (2017). Managerial Accounting: Tools for Business Decision-Making, Canadian Edition, 5th Edition. [[VitalSource Bookshelf version]]. Retrieved from vbk://9781119403999 Always check citation for accuracy before use.

Company B sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 6%. For years, Company B believed that the 6% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Company B decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:

Company B gathered the data below for two of the many hospitals that it serves—University and Memorial (each hospital purchased medical supplies that had cost Company B $30,000 to buy from manufacturers):

1. Compute the total revenue that Company B would receive from University and from Memorial.

2. Compute the activity rate for each activity cost pool. (customer deliveries, manual order processing, electronic order processing, line item picking)

3. Compute the total activity costs that would be assigned to University and to Memorial.

4. Compute Company B's customer margin for University and for Memorial. (Hint: Do not overlook the $30,000 cost of goods sold that Company B incurred serving each hospital.)

Special-Order Decision, Traditional Analysis, Qualitative Aspects

Feinan Sports, Inc., manufactures sporting equipment, including weight-lifting gloves. A national sporting goods chain recently submitted a special order for 4,000 pairs of weight-lifting gloves. Feinan Sports was not operating at capacity and could use the extra business. Unfortunately, the order’s offering price of $12.70 per pair was below the cost to produce them. The controller was opposed to taking a loss on the deal. However, the personnel manager argued in favor of accepting the order even though a loss would be incurred; it would avoid the problem of layoffs and would help maintain the community image of the company. The full cost to produce a pair of weight-lifting gloves is presented below.

No variable selling or administrative expenses would be associated with the order. Non-unit-level activity costs are a small percentage of total costs and are therefore not considered.

1. Assume that the company would accept the order only if it increased total profits. Should the company accept or reject the order?
Reject

Provide supporting computations. If required, round your answers to the nearest cent. Enter a loss as a negative amount.

Total decrease  in income: $

2. Suppose that Feinan Sports has negotiated with the potential customer, and has determined that it can substitute cheaper materials, reducing direct materials cost by $0.80 per unit. In addition, the company’s engineers have found a way to reduce direct labor cost by $0.40 per unit. Should the company accept or reject the order?
Accept

Provide supporting computations. If required, round your answers to the nearest cent. Enter a loss as a negative amount.

Total increase  in income: $

Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Molding Fabrication Total Estimated total machine-hours used 2,500 1,500 4,000 Estimated total fixed manufacturing overhead $ 14,750 $ 17,850 $ 32,600 Estimated variable manufacturing overhead per machine-hour $ 3.30 $ 4.10 Job P Job Q Direct materials $ 32,000 $ 17,500 Direct labor cost $ 36,200 $ 15,100 Actual machine-hours used: Molding 3,600 2,700 Fabrication 2,500 2,800 Total 6,100 5,500 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month.

Required: For questions 1-8, assume that Sweeten Company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. For questions 9-15, assume that the company uses departmental predetermined overhead rates with machine-hours as the allocation base in both departments.

12.If Job P included 20 units, what was its unit product cost?

13.If Job Q included 30 units, what was its unit product cost?

14.Assume that Sweeten Company used cost-plus pricing (and a markup percentage of 80% of total manufacturing cost) to establish selling prices for all of its jobs. What selling price would the company have established for Jobs P and Q? What are the selling prices for both jobs when stated on a per unit basis assuming 20 units were produced for Job P and 30 units were produced for Job Q?

15.What was Sweeten Company’s cost of goods sold for March?

DO NOT COPY FROM THE WEB.

Provide a narrative analysis in Word FOR QUESTION 4-6. Your narrative analysis should summarize the results of your analysis and make recommendations for the benefit of the company.

Question 4: Based on profit-maximization analysis, what level of output should you recommend to the CEO?

Question 5: Using the above information, prepare a budget for May 20X8, stating the total cost. Use a spreadsheet to display your data and calculations.

Question 6: With the costs that you calculate, what is the profit or loss associated with MiniY? NOTE: Assume that the variable and fixed costs mentioned in Step 5 are also applicable to Step 6 when calculating the profit or loss for MiniY

Expert Answer

On March 1, 2019, Baltimore Company's beginning work in process inventory had 7,500 units. This is its only production department. Beginning WIP units were 50% complete as to conversion costs. Baltimore introduces direct materials at the beginning of the production process.  During March, a total of 21,800 units were started and the ending WIP inventory had 7,400 units which were 40% complete as to conversion costs. Baltimore uses the weighted average method. Use this information to determine for March 2019 the equivalent units of production for conversion costs. (Round answer to the nearest whole number of units)

On March 1, 2019, Annapolis Company has a beginning Work in Process inventory of zero. All materials are added into production at the beginning of its production. There is only one production WIP inventory. During the month 37,000 units were started. At the end of the month all started units were 75% complete with respect to conversion. Direct Materials placed into production had a total cost of $335,000 and the total conversion cost for the month was $308,000. Annapolis uses the weighted-average process costing method. Use this information to determine the cost per equivalent unit of direct material for the month of March. (Round answer to the nearest cent.)

On March 1, 2019, Annapolis Company has a beginning Work in Process inventory of zero. All materials are added into production at the beginning of its production. There is only one production WIP inventory. During the month 27,000 units were started. At the end of the month all started units were 60% complete with respect to conversion. Direct Materials placed into production had a total cost of $310,000 and the total conversion cost for the month was $493,000. Annapolis uses the weighted-average process costing method. Use this information to determine the cost per equivalent unit of conversion for the month of March. (Round answer to the nearest cent.)

Chapter 7 - problem 18

Activity cost Pool                                         Activity Measure                       Total Activity

Removing asbestos ………………. Thousands of square feet              800 thousand square feet

Equipment and job steps…………. Number of jobs                              500 jobs

Working on nonroutine jobs………. Number of jobs nonroutine jobs    100 nonroutine jobs                   

Other organization-sustaining costs and idle capacity costs …………… None

Note The 100 nonrountine jobs are included in the total of 500 jobs. Both nonroutine jobs and routine jobs require estimating and steps.

Cots for the Year

Wages and salaries ……………………………………………… $300,000

Disposal fees ……………………………………………………… 700,000

Equipment depreciation …………………………………………. 90,000

One-site suppliers ………………………………………………… 50,000

Office expenses …………………………………………………… 200,000

License and insurance ……………………………………………. 400,000

Total cost …………………………………………………………… 51,740,000

Distribution of Resource Consumption across Activities

                                                                      Estimating               Working on

                                             Removing         and job steps          Nonroutine jobs        

                                               Asbestos                                                                  other   Total

Wages and salaries                  50%                10%                    30%                     10%    100%

Disposal fees                            60%                 0%                     40%                      0%      100%

Equipment depreciation           40%                  5%                     20%                      35%    100%

One-site suppliers                   60%                 30%                   10%                       0%      100%

Office expenses                       10%                 35%                    25%                      30%    100%

License and insurance             30%                 0%                     50%                      20%     100%

Require

1. Using Exhibit 7-6 as a guide, perform the first-stage allocation of costs to the activity cost pools.
2. Using Exhibit 7-7 as a guide, compute the activity rates for the activity cost pools.
3. Using the activity rates you have computed, determine the total cost and the average cost per thousand square feet of each of the following jobs according to the activity-based costing system.

1. A routine 1.000-square-foot asbestos removal job.
2. A routine 2.000-square-foot asbestos removal job
3. A nonroutine 2 000-square-foot asbestos removal job.

4. Given the results you obtained in (3) above, do you agree with the estimator that the company's present policy for bidding on jobs is adequate?

Worley Company buys surgical supplies from a variety of manufacturers and then resells and delivers these supplies to hundreds of hospitals. Worley sets its prices for all hospitals by marking up its cost of goods sold to those hospitals by 5%. For example, if a hospital buys supplies from Worley that cost Worley $100 to buy from manufacturers, Worley would charge the hospital $105 to purchase these supplies.

For years, Worley believed that the 5% markup covered its selling and administrative expenses and provided a reasonable profit. However, in the face of declining profits, Worley decided to implement an activity-based costing system to help improve its understanding of customer profitability. The company broke its selling and administrative expenses into five activities as shown:

Worley gathered the data below for two of the many hospitals that it serves—University and Memorial (each hospital purchased medical supplies that had cost Worley $36,000 to buy from manufacturers):

Required:

1. Compute the total revenue that Worley would receive from University and Memorial.

2. Compute the activity rate for each activity cost pool.

3. Compute the total activity costs that would be assigned to University and Memorial.

4. Compute Worley’s customer margin for University and Memorial.