Questions
Using Regression to Calculate Fixed Cost, Calculate the VariableRate, Construct a Cost Formula, and Determine...

Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost

Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:

MonthLabor CostEmployee Hours
January$7,200

360
February8,140

550
March9,899

630
April9,787

590
May8,490

480
June7,450

350
July9,490

570
August7,531

310

Coefficients shown by a regression program for Pizza Vesuvio's data are:

Intercept4,613
X Variable8.09

In your calculations, round the variable rate per employee hour to the nearest cent.

Required:

Use the results of regression to make the following calculations:

1. Calculate the fixed cost of labor.
$

Calculate the variable rate per employee hour.
$per employee hour

2. Construct the cost formula for total labor cost.
Total labor cost = $ + ($ × Employee hours)

3. Calculate the budgeted cost for next month, assuming that 690 employee hours are budgeted. Round answer to the nearest dollar.
$

In: Accounting

Builder Products, Inc., uses the weighted-average method in its process costing system. It manufactures a caulking...

Builder Products, Inc., uses the weighted-average method in its process costing system. It manufactures a caulking compound that goes through three processing stages prior to completion. Information on work in the first department, Cooking, is given below for May:

Production data:
Pounds in process, May 1; materials 100% complete;
conversion 90% complete
88,000
Pounds started into production during May 530,000
Pounds completed and transferred out ?
Pounds in process, May 31; materials 60% complete;
conversion 40% complete
65,000
Cost data:
Work in process inventory, May 1:
Materials cost $ 106,000
Conversion cost $ 59,700
Cost added during May:
Materials cost $ 551,120
Conversion cost $ 328,230

Required:

1. Compute the equivalent units of production for materials and conversion for May.

2. Compute the cost per equivalent unit for materials and conversion for May.

3. Compute the cost of ending work in process inventory for materials, conversion, and in total for May.

4. Compute the cost of units transferred out to the next department for materials, conversion, and in total for May.

In: Accounting

Osborn Manufacturing uses a predetermined overhead rate of $18.30 per direct labor-hour. This predetermined rate was...

Osborn Manufacturing uses a predetermined overhead rate of $18.30 per direct labor-hour. This predetermined rate was based on a cost formula that estimates $221,430 of total manufacturing overhead for an estimated activity level of 12,100 direct labor-hours.

     The company incurred actual total manufacturing overhead costs of $217,000 and 11,600 total direct labor-hours during the period.

   

Required:
1.

Determine the amount of underapplied or overapplied manufacturing overhead for the period.

          

2.

Assuming that the entire amount of the underapplied or overapplied overhead is closed out to cost of goods sold, what would be the effect of the underapplied or overapplied overhead on the company's gross margin for the period?

       

In: Accounting

Rita Corporation produces commercial fertilizer spreaders. The following information is available for Rita's anticipated annual volume...

Rita Corporation produces commercial fertilizer spreaders. The following information is available for Rita's anticipated annual volume of 600,000 units:

       Per Unit                                                                           Total

       Direct materials                                                                  $37

       Direct labour                                                                        43

       Variable manufacturing overhead                                        65

       Fixed manufacturing overhead                            $15,000,000

       Variable selling and administrative expenses                      73

       Fixed selling and administrative expenses             11,400,000

The company has a desired ROI of 20%. It has invested assets of $325,000,000.

Required:

Calculate each of the following:

  1. Total cost per unit.
  1. Desired ROI per unit.
  1. Mark-up percentage using total cost per unit.
  1. Target selling price.

In: Accounting

Cretin Enterprises uses a predetermined overhead rate of $21.40 per direct labor-hour. This predetermined rate was...

Cretin Enterprises uses a predetermined overhead rate of $21.40 per direct labor-hour. This predetermined rate was based on a cost formula that estimated $171,200 of total manufacturing overhead for an estimated activity level of 8,000 direct labor-hours.   

The company incurred actual total manufacturing overhead costs of $172,500 and 8,250 total direct labor-hours during the period.

Required:

1. Determine the amount of underapplied or overapplied manufacturing overhead for the period.

        

2. Assuming that the entire amount of the underapplied or overapplied overhead is closed out to cost of goods sold, what would be the effect of the underapplied or overapplied overhead on the company's gross margin for the period?

     

In: Accounting

Total assets turnover: 1x Days sales outstanding: 37 daysa Inventory turnover ratio: 6x Fixed assets turnover:...

Total assets turnover: 1x Days sales outstanding: 37 daysa Inventory turnover ratio: 6x Fixed assets turnover: 3x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $ Current liabilities $ Accounts receivable Long-term debt 30,000 Inventories Common stock Fixed assets Retained earnings 60,000 Total assets $200,000 Total liabilities and equity $ Sales $ Cost of goods sold $

In: Finance

Counting Services Inc. has the following portfolio of trading equity securities at 12/31/17. All securities were...

Counting Services Inc. has the following portfolio of trading equity securities at 12/31/17. All securities were purchased during 2017.

Symbol # shares Total Cost Market Value

AAPL 1000 $102,000 $107,000

BMX 2000 $47,000 $41,000

GNC 3000 $64,000 $87,000

Total $213,000

• Prepare the adjustment necessary at 12/31/17.

• On February 12, 2018, Counting Services sells 1,000 shares of AAPL for $115,000. Prepare the journal entry.

• The total cost of the two remaining securities is $111,000 and the market value is $130,000 at March 31, 2018. Prepare the adjusting entry.

In: Accounting

Assume that during the past m onth, Fineway produced 10,000 cartons of highlighters. Highlighters has a...

Assume that during the past m onth, Fineway produced 10,000 cartons of highlighters. Highlighters has a translucent barrel and cap with a visible ink supply for see through colour. The special fluorescent ink is fade and water resistance. Each carton contains 100 boxes of markers and each box contains five markers. The markers come in boxes of one of five fluorescent colours- orange, blue, yellow, green and pink and in a fivc colour set. The standard cost for one carton of 500 markers is as follows: Standard Manufacturing Cost Elements Quantity Price Cost Direct materials Tips (boxes of 500 Translucent barrels and caps (boxes of 500 Fluorescent ink (5 litre container) x $o.03 X $O.09 = $45.00 X $6.40 $32.00 500 $15.00 500 Slitre Total direct material = $92.00 Direct labour 0.25 hours X $9.00 $2.25 0.25 hours X $48.00 $12.00 = $106.25 Overhead Total cost of production During the month, the following transactions occurred in manufacturing 10,000 cartons of highlighters: 1) Purchased 10,000 boxes of tips for $148,000, ($14.80 per 500 tips), Purchased 10,200 boxes of translucent barrels and caps for $453,900 ($44.50 per 500 barrels and caps) and purchased 9,900 containers of fluorescent ink for $328,185 ( $33.15 per five litre container). 2) All materials purchased during the period were used to make markers during the period. 3) A total of 2,300 direct labour hours were worked at a total labour cost of $20, 240 ( an average hourly rate of $8.80) 4) The variable manufacturing overhead incurred was $34,600 and the fixed overhead incurred was $84,000 5) The manufacturing overhead rate of $48.00 is based on a normal capacity of 2,600 direct labour hours. The total budget at this capacity is $83,980 fixed and $40,820 variable. Required;

a) Calculate the total actual cost incurred
b) Calculate the total standard costs for the actual quantity produced
Using the same data in question 3 answer the following questions:
a) Calculate the total direct material variances (price and volume/quantity)
B) Calculate direct labour variances (Rate and efficiency)
c) Calculate the total overhead variance (Fixed and variable overhead)
D) Determine whether Fineway met its price and quantity objectives for materials, labour and
overhead.
(For the variances calculated you should indicate if it is favourable (F) or unfavourable (U))

In: Accounting

Eire Products is a specialty lubricants company. The Lake Plant produces a single product in three...

Eire Products is a specialty lubricants company. The Lake Plant produces a single product in three departments: Filtering, Blending, and Packaging. Additional materials are added in the Blending Process when units are 50 to 55 percent complete with respect to conversion. Information for operations in June in the Blending process appear as follows.

Work in process on June 1 consisted of 12,000 barrels with the following costs.

Amount Degree of Completion
Filtering costs transferred in $ 11,440 100 %
Costs added in Blending
Direct materials $ 0 0 %
Conversion costs 20,810 30 %
$ 20,810
Work in process June 1 $ 32,250

During June, 131,000 barrels were transferred in from Filtering at a cost of $388,960. The following costs were added in Blending in June.

Direct materials $ 657,800
Conversion costs 1,026,470
Total costs added $ 1,684,270

Blending finished 130,000 barrels in June and transferred them to Packaging. At the end of June, there were 13,000 barrels in work in process inventory. The units were 60 percent complete with respect to conversion costs.

The Blending Department uses the weighted-average method of process costing. The Filtering Department at Eire uses the FIFO method of process costing. The cost analyst in Blending has learned that if the Filtering Department at Eire had used the weighted average method, the amount of costs transferred in from Filtering would have been $14,840 in the beginning work in process and $167,660 for the amount transferred in this month.

Required:

Prepare a production cost report for June for the Blending Department. (Round "Cost per equivalent unit" to 2 decimal places.)

EIRE PRODUCTS
Blending Department
Production Cost Report—Weighted-Average
Physical units Total Costs Prior Department Costs Materials Conversion
Flow of Production Units
Units to be accounted for:
Beginning WIP inventory
Units started this period
Total units to be accounted for 0
Units accounted for:
Units completed and transferred out:
From beginning inventory
Started and completed currently
Total transferred out 0
Units in ending WIP inventory
Total units accounted for 0 0 0 0
Costs to be accounted for:
Costs in beginning WIP inventory
Current period costs
Total costs to be accounted for $0 $0 $0 $0
Cost per equivalent unit:
Prior department costs
Materials
Conversion
Costs accounted for:
Costs assigned to units transferred out:
Prior department costs
Materials
Conversion
Total costs of units transferred out $0
Costs assigned to ending WIP inventory:
Prior department costs
Materials
Conversion
Total ending WIP inventory $0
Total costs accounted for

In: Accounting

Eire Products is a specialty lubricants company. The Lake Plant produces a single product in three...

Eire Products is a specialty lubricants company. The Lake Plant produces a single product in three departments: Filtering, Blending, and Packaging. Additional materials are added in the Blending Process when units are 50 to 55 percent complete with respect to conversion. Information for operations in June in the Blending process appear as follows.

Work in process on June 1 consisted of 12600 barrels with the following costs.

Amount

Degree of Completion

Filtering costs transferred in

$

11620

100

%

Costs added in Blending

Direct materials

$

0

0

%

Conversion costs

21305

30

%

$

21305

Work in process June 1

$

32925

During June, 134000 barrels were transferred in from Filtering at a cost of $442,840. The following costs were added in Blending in June.

Direct materials

$

718,340

Conversion costs

1,136,207

Total costs added

$

1,854,547

Blending finished 133,000 barrels in June and transferred them to Packaging. At the end of June, there were 13,600 barrels in work in process inventory. The units were 60 percent complete with respect to conversion costs.

The Blending Department uses the weighted-average method of process costing. The Filtering Department at Eire uses the FIFO method of process costing. The cost analyst in Blending has learned that if the Filtering Department at Eire had used the weighted average method, the amount of costs transferred in from Filtering would have been $15,740 in the beginning work in process and $171,260 for the amount transferred in this month.

Required:

Prepare a production cost report for June for the Blending Department. (Round "Cost per equivalent unit" to 2 decimal places.)

EIRE PRODUCTS
Blending Department
Production Cost Report—Weighted-Average
Physical units Total Costs Prior Department Costs Materials Conversion
Flow of Production Units
Units to be accounted for:
Beginning WIP inventory
Units started this period
Total units to be accounted for 0
Units accounted for:
Units completed and transferred out:
From beginning inventory
Started and completed currently
Total transferred out 0
Units in ending WIP inventory
Total units accounted for 0 0 0 0
Costs to be accounted for:
Costs in beginning WIP inventory
Current period costs
Total costs to be accounted for $0 $0 $0 $0
Cost per equivalent unit:
Prior department costs
Materials
Conversion
Costs accounted for:
Costs assigned to units transferred out:
Prior department costs
Materials
Conversion
Total costs of units transferred out $0
Costs assigned to ending WIP inventory:
Prior department costs
Materials
Conversion
Total ending WIP inventory $0
Total costs accounted for

In: Accounting