Required information
[The following information applies to the questions displayed below.]
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,500 | $ | 17,700 | $ | 32,200 | |||
| Estimated variable manufacturing overhead per machine-hour | $ | 3.20 | $ | 4.00 | |||||
| Job P | Job Q | |||||
| Direct materials | $ | 31,000 | $ | 17,000 | ||
| Direct labor cost | $ | 35,400 | $ | 14,700 | ||
| Actual machine-hours used: | ||||||
| Molding | 3,500 | 2,600 | ||||
| Fabrication | 2,400 | 2,700 | ||||
| Total | 5,900 | 5,300 | ||||
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.
4. If Job P included 20 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
5- What was the total manufacturing cost assigned to Job Q? (Do not round intermediate calculations.)
6- If Job Q included 30 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.)
7- 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? (Do not round intermediate calculations. Round your final answers to nearest whole dollar.)
8 8. What was Sweeten Company’s cost of goods sold for March? (Do not round intermediate calculations.)
In: Economics
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 9,000 barrels with the following costs.
|
|
Amount |
Degree of completion |
||
|
Filtering costs transferred in |
$ 11,700 |
100% |
||
|
Cost added in Blending |
||||
|
Direct materials |
$ - |
0% |
||
|
Conversion costs |
$ 18,335 |
30% |
||
|
Work in process June 1 |
$ 30,035 |
|||
During June, 116,000 barrels were transferred in from Filtering at a cost of $150,800. The following costs were added in Blending in June.
|
Direct materials |
$ 387,500 |
|
Conversion costs |
$ 538,265 |
|
Total costs added |
$ 925,765 |
Blending finished 115,000 barrels in June and transferred them to Packaging. At the end of June, there were 10,000 barrels in work-in-process inventory. The units were 60 percent complete with respect to conversion costs. The Blending Department uses FIFO method of process costing.
Required: Prepare a cost of production report for Blending department for June.
|
A |
B |
C |
D |
|
|
1 |
(Step 1) |
(Step 2) Equivalent Units |
||
|
2 |
||||
|
3 |
Flow of production |
Physical units |
Direct Material |
Conversion Cost |
|
4 |
Beginning WIP |
9,000 |
Work done before current period |
|
|
5 |
Started during current period |
116,000 |
||
|
6 |
To Account For |
125,000 |
||
|
7 |
Completed and transferred out during current period: |
115,000 |
||
|
8 |
From beginning WIP |
9,000 |
||
|
9 |
{9000 x (100% -50%); 9000 x (100% - 55%) |
4500 |
4950 |
|
|
10 |
Started and completed |
106,000 |
||
|
11 |
(106,000 x 100%; 106,000 x 100%) |
106,000 |
106,000 |
|
|
12 |
Ending WIP |
10,000 |
||
|
13 |
10,000 x 100%; 10,000 x 60% |
10,000 |
6,000 |
|
|
14 |
Accounting for |
125,000 |
||
|
15 |
Equivalent units of work done in current period |
120,500 |
116,950 |
|
|
16 |
||||
|
Total Production Costs |
Direct Material |
Conversion Costs |
|||
|
Step 3 |
Beginning WIP |
+ |
|||
|
Cost added in current period |
+ |
||||
|
Total costs to account for |
+ |
||||
|
Step 4 |
Cost added in current period |
||||
|
Divide by equivalent units of work done in current period |
|||||
|
Costs per equivalent unit of work done in current period |
|||||
|
Step 5 |
Assignment of costs: |
||||
|
Completed and transferred out |
|||||
|
Beginning WIP |
+ |
||||
|
Costs added to beginning WIP in current period |
+ |
||||
|
Total from beginning inventory |
|||||
|
Started and completed |
+ |
||||
|
Total cost of units completed and transferred out |
|||||
|
Ending WIP |
+ |
||||
|
Total costs accounted for |
+ |
||||
In: Accounting
Boston Corporation has two production departments, Assembly and Machining, and two service departments, Personnel and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of July, 2020 are as follows:
|
Proportion of Services Used by: |
||||||||||||||||||||
|
Department |
Direct costs |
Personnel |
Cafeteria |
Machining |
Assembly |
|||||||||||||||
|
Personnel |
$ |
30,000 |
0.40 |
0.30 |
0.30 |
|||||||||||||||
|
Cafeteria |
$ |
50,000 |
0.20 |
0.50 |
0.30 |
|||||||||||||||
|
Machining |
$ |
80,000 |
||||||||||||||||||
|
Assembly |
$ |
70,000 |
||||||||||||||||||
Required: (use ANOTHER sheet to show your work AND PLACE IT IN THE drop box FOR test #3) 10 points
Show the total costs allocated to each Producing Department AND Total Costs in each Producing Department after allocated Costs.
a, Allocated Costs to MACHINING ___________________ b. Allocated Cost to ASSEMBLY_________________________
c. Total Costs to MACHINING________________________ d. Total Costs to ASSEMBLY____________________________
e. Allocated Costs to MACHINING ___________________ f. Allocated Cost to ASSEMBLY_________________________
g. Total Costs to MACHINING________________________ h. Total Costs to ASSEMBLY____________________________
In: Accounting
Feeders manufactures bird feeders for wild bird specialty stores. In? September,
WilsonWilson
Feeders received an order from Wild? Birds, Inc., for
3232
platform bird feeders. The order from Wild? Birds, Inc., became Job Number 1102 at
WilsonWilson
Feeders. A materials requisition for Job 1102 is presented to the right. In addition to the materials?requisition, the labor time records? (partial) for the week during which these feeders were made are presented. Other products were also being produced during that? week, so not all of the labor from that week belongs to Job 1102.??
LOADING...
?(Click the icon to view the materials? requisition.)
LOADING...
?(Click the icon to view the labor time? records.)
LOADING...
?(Click the icon to view the job cost? record.)Read the requirements
LOADING...
.
Requirement 1. Calculate the total for the Materials Requisition form. Post the information? (cost and requisition? number) from the Materials Requisition form to the Job Cost Record in the appropriate boxes.
Complete the Materials Requisition form. In Requirement 3 you will post the information? (cost and requisition? number) from the Materials Requisition form to the Job Cost Record in the appropriate boxes.
|
Materials Requisition |
|||||
|
Number: #1250 |
|||||
|
Date: |
9/14 |
||||
|
Job: |
1102 |
||||
|
Part number |
Description |
Quantity |
Unit Cost |
Amount |
|
|
WOCD06 |
Rough-hewn cedar planks |
42 |
$2.00 |
$84 |
|
|
SSF0304 |
Stainless steel fasteners |
84 |
$0.50 |
42 |
|
|
AS222 |
Reinforced aluminum screens |
20 |
$1.50 |
30 |
|
|
Total |
$156 |
||||
Requirement 2. Complete the labor time records for each of the employees. Once the labor time record is? completed, post the information relevant to Job 1102 to the Job Cost Record for Job Cost 1102.
Complete the labor time records for each of the employees. In Requirement 3 you will post the information relevant to Job 1102 to the Job Cost Record for Job Cost 1102. Begin with employee Greg Henderson.
|
Labor Time Record |
||||||
|
Employee: |
Greg Henderson |
Week: |
9/14-9/20 |
|||
|
Hourly Wage Rate: |
$14 |
Record #: |
912 |
|||
|
Date |
Job number |
Start Time |
End Time |
Hours |
Cost |
|
|
9/14 |
1102 |
8:00 |
12:00 |
4 |
$56 |
|
|
9/14 |
1103 |
12:00 |
4:00 |
4 |
$56 |
|
|
9/15 etc. |
||||||
Now complete the labor time record for employee Andrew Peck.
|
Labor Time Record |
||||||
|
Employee: |
Andrew Peck |
Week: |
9/14-9/20 |
|||
|
Hourly wage rate: |
$7 |
Record #: |
913 |
|||
|
Date |
Job number |
Start Time |
End Time |
Hours |
Cost |
|
|
9/14 |
1101 |
8:00 |
1:00 |
5 |
$35 |
|
|
9/14 |
1102 |
1:00 |
4:00 |
3 |
$21 |
|
|
9/15 |
1103 |
8:00 |
10:00 |
2 |
$14 |
|
|
9/15 etc. |
||||||
Requirement 3. Manufacturing overhead has already been added to the Job Cost Record. Complete the Job Cost Record by calculating the total job cost and the cost per unit. Remember that this job consisted of
3232
feeders?(units).Post the direct material information? (cost and requisition? number) from the Materials Requisition form and direct labor information relevant to Job 1102 to the Job Cost Record for Job Cost 1102. Complete the Job Cost Record by calculating the total job cost and the cost per unit. Remember that this job consisted of
3232
feeders? (units). ?(Round the cost per unit to the nearest? cent.)View the completed labor time records
LOADING...
.
|
Job Cost Record |
|||
|
Job Number: |
1102 |
||
|
Customer: |
Wild Birds, Inc. |
||
|
Job description: |
32 Model 3F (platform bird feeders) |
||
|
Date Started: |
Sep. 14 |
Date Completed: |
|
|
Manufacturing Cost Information: |
Cost Summary |
||
|
Direct Materials |
|||
|
Req. # : |
1250 |
$156 |
|
|
Direct Labor |
|||
|
No. # |
912 |
||
|
No. # |
913 |
||
|
Manufacturing Overhead |
|||
|
7 hours x $2 per direct labor hour |
$14 |
||
|
Total Job Cost |
|||
|
Number of Units |
÷ |
32 |
|
|
Cost per Unit |
|||
In: Accounting
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown:
| Hi-Tek Manufacturing Inc. Income Statement |
|||
| Sales | $ | 1,755,900 | |
| Cost of goods sold | 1,218,631 | ||
| Gross margin | 537,269 | ||
| Selling and administrative expenses | 550,000 | ||
| Net operating loss | $ | (12,731 | ) |
Hi-Tek produced and sold 60,400 units of B300 at a price of $21 per unit and 12,500 units of T500 at a price of $39 per unit. The company’s traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:
| B300 | T500 | Total | ||||
| Direct materials | $ | 400,800 | $ | 162,600 | $ | 563,400 |
| Direct labor | $ | 120,600 | $ | 42,800 | 163,400 | |
| Manufacturing overhead | 491,831 | |||||
| Cost of goods sold | $ | 1,218,631 | ||||
The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek’s ABC implementation team concluded that $55,000 and $102,000 of the company’s advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company’s manufacturing overhead to four activities as shown below:
| Manufacturing Overhead |
Activity | |||||
| Activity Cost Pool (and Activity Measure) | B300 | T500 | Total | |||
| Machining (machine-hours) | $ | 203,091 | 90,400 | 62,300 | 152,700 | |
| Setups (setup hours) | 128,040 | 71 | 220 | 291 | ||
| Product-sustaining (number of products) | 100,600 | 1 | 1 | 2 | ||
| Other (organization-sustaining costs) | 60,100 | NA | NA | NA | ||
| Total manufacturing overhead cost | $ | 491,831 | ||||
Required:
1. Compute the product margins for the B300 and T500 under the company’s traditional costing system.
| B300 | T500 | Total | |
| Product Margin | ? | ? | ? |
2. Compute the product margins for B300 and T500 under the activity-based costing system.
| B300 | T500 | Total | |
| Product Margin | ? | ? | ? |
3. Prepare a quantitative comparison of the traditional and activity-based cost assignments.
In: Accounting
Silven Industries, which manufactures and sells a highly successful line of summer lotions and insect repellents, has decided to diversify in order to stabilize sales throughout the year. A natural area for the company to consider is the production of winter lotions and creams to prevent dry and chapped skin.
After considerable research, a winter products line has been developed. However, Silven’s president has decided to introduce only one of the new products for this coming winter. If the product is a success, further expansion in future years will be initiated.
The product selected (called Chap-Off) is a lip balm that will be sold in a lipstick-type tube. The product will be sold to wholesalers in boxes of 24 tubes for $8 per box. Because of excess capacity, no additional fixed manufacturing overhead costs will be incurred to produce the product. However, a $90,000 charge for fixed manufacturing overhead will be absorbed by the product under the company’s absorption costing system.
Using the estimated sales and production of 100,000 boxes of Chap-Off, the Accounting Department has developed the following cost per box:
| Direct materials | $ | 3.60 | |
| Direct labor | 2.00 | ||
| Manufacturing overhead | 1.40 | ||
| Total cost | $ | 7.00 | |
|
|
|||
The costs above include costs for producing both the lip balm and the tube that contains it. As an alternative to making the tubes, Silven has approached a supplier to discuss the possibility of purchasing the tubes for Chap-Off. The purchase price of the empty tubes from the supplier would be $1.35 per box of 24 tubes. If Silven Industries accepts the purchase proposal, direct labor and variable manufacturing overhead costs per box of Chap-Off would be reduced by 10% and direct materials costs would be reduced by 25%.
3. Instead of sales of 100,000 boxes, revised estimates show a sales volume of 120,000 boxes. At this new volume, additional equipment must be acquired to manufacture the tubes at an annual rental of $40,000. Assume that the outside supplier will not accept an order for less than 120,000 boxes.
a. Calculate the total relevant cost of making 120,000 boxes and total relevant cost of buying 120,000 boxes. (Do not round intermediate calculations.)
Total Cost Making
Total Cost Buying
In: Accounting
Salespersons' Report and Analysis
Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows:
| Salesperson | Total Sales | Variable Cost of Goods Sold | Variable Selling Expenses | |||||
| Case | $343,000 | $174,930 | $44,590 | |||||
| Dix | 558,000 | 212,040 | 89,280 | |||||
| Johnson | 500,000 | 250,000 | 80,000 | |||||
| LaFave | 463,000 | 217,610 | 74,080 | |||||
| Orcas | 499,000 | 209,580 | 94,810 | |||||
| Sussman | 338,000 | 121,680 | 74,360 | |||||
| Willbond | 452,000 | 144,640 | 85,880 | |||||
Required:
1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers.
| Waltham Industries Inc. | ||||
| Salespersons' Analysis | ||||
| For the Year Ended December 31 | ||||
| Salesperson | Contribution Margin | Variable Cost of Goods Sold as a Percent of Sales | Variable Selling Expenses as a Percent of Sales | Contribution Margin Ratio |
| Case | $ | % | % | % |
| Dix | % | % | % | |
| Johnson | % | % | % | |
| LaFave | % | % | % | |
| Orcas | % | % | % | |
| Sussman | % | % | % | |
| Willbond | % | % | % | |
Feedback
Calculate:
Column 1: Contribution margin = Total sales – (Variable cost of
goods sold + Variable selling expenses)
Column 2: Variable cost of goods sold as a percent of sales =
Variable cost of goods sold/Total sales
Column 3: Variable selling expenses as a percent of sales =
Variable selling expenses/Total sales
Column 4: Contribution margin ratio = Contribution margin/Total
sales
Learning Objective 4.
2. Which salesperson generated the highest contribution margin ratio for the year?
Willbond
Feedback
Learning Objective 4.
3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons.
5
In: Accounting
Walthman Industries Inc. employs seven salespersons to sell and distribute its product throughout the state. Data taken from reports received from the salespersons during the year ended December 31 are as follows:
| Salesperson | Total Sales | Variable Cost of Goods Sold | Variable Selling Expenses | |||||
| Case | $366,000 | $161,040 | $54,900 | |||||
| Dix | 528,000 | 300,960 | 68,640 | |||||
| Johnson | 581,000 | 313,740 | 92,960 | |||||
| LaFave | 448,000 | 255,360 | 58,240 | |||||
| Orcas | 389,000 | 140,040 | 62,240 | |||||
| Sussman | 323,000 | 171,190 | 54,910 | |||||
| Willbond | 422,000 | 143,480 | 75,960 | |||||
Required:
1. Prepare a table indicating contribution margin, variable cost of goods sold as a percent of sales, variable selling expenses as a percent of sales, and contribution margin ratio by salesperson. Round percents to the nearest whole number. Enter all amounts as positive numbers.
| Waltham Industries Inc. | ||||
| Salespersons' Analysis | ||||
| For the Year Ended December 31 | ||||
| Salesperson | Contribution Margin | Variable Cost of Goods Sold as a Percent of Sales |
Variable Selling Expenses as a Percent of Sales |
Contribution Margin Ratio |
| Case | $ | % | % | % |
| Dix | % | % | % | |
| Johnson | % | % | % | |
| LaFave | % | % | % | |
| Orcas | % | % | % | |
| Sussman | % | % | % | |
| Willbond | % | % | % | |
Feedback
Calculate:
Column 1: Contribution margin = Total sales – (Variable cost of goods sold + Variable selling expenses)
Column 2: Variable cost of goods sold as a percent of sales = Variable cost of goods sold/Total sales
Column 3: Variable selling expenses as a percent of sales = Variable selling expenses/Total sales
Column 4: Contribution margin ratio = Contribution margin/Total sales
2. Which salesperson generated the highest contribution margin ratio for the year?
Feedback
2. The salesperson who generated the highest contribution margin ratio for the year, probably sells a favorable mix of product that has high manufacturing margins as a percent of sales.
3. Identify the factors other than contribution margin that should be considered in evaluating the performance of salespersons.
In: Accounting
Arnett Corp. manufactures computer desks in its
White Bear LakeWhite Bear Lake,
MinnesotaMinnesota,
plant. The company uses activity-based costing to allocate all manufacturing conversion costs (direct labor and manufacturing overhead). Its activities and related data follow.
LOADING...
(Click the icon to view the activity areas and related data.)
Requirements
|
1. |
Compute the per-unit manufacturing product cost of Standard desks and Unpainted desks. |
|
2. |
Premanufacturing activities, such as product design, were
assigned to the Standard desks at
$ 6$6 each and to the Unpainted desks at$ 2$2 each. Similar analyses were conducted of post-manufacturing activities, such asdistribution, marketing, and customer service. The post-manufacturing costs were$ 22$22 per Standard and$ 19$19 per Unpainted desk. Compute the full product costs per desk. |
|
3. |
Which product costs are reported in the external financial statements? Which costs are used for management decision making? Explain the difference. |
|
4. |
What
price should
Arnett'sArnett's managers set for Standard desks to earn a$ 42$42 profit per desk? |
Requirement 1. Compute the per-unit manufacturing product cost of Standard desks and Unpainted desks. (Complete all input boxes. Enter a "0" for any zero amounts. Round your answers to the nearest whole dollar.)
|
Standard Desk |
Unpainted Desk |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Direct materials |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Materials handling |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Assembling |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Painting |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Total manufacturing cost |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Number of units |
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Manufacturing cost per unit DATA TABLE
ArnettArnett produced two styles of desks in March: the Standard desk and Unpainted desk. Data for each follow:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
Your manufacturing facility produces three styles of coffee tables for its customers. All three of the tables use the same Baltic birch plywood oval and then are treated differently to create the final products. The Waltons model has a natural wood finish and wooden legs. The jetsons model has aluminum sheet laminated to the wood base and aluminum legs. The Miami vice model has hot pink finish applied and black iron legs. The plywood ovals are manufactured in a process environment. Then, they are transferred to the next department where they undergo transformation into the finished products. The second department is a job-order cost environment.
Using the data on this page, prepare the process cost summary on the blank form provided. Then, using your answer from the process cost summary and other information provided, complete the job-order cost report by computing manufacturing cost per unit for each of the three models. Please not that the job order cost report is not complete – you’ll need to add some lines to arrive at your final manufacturing costs per unit.
Raw materials Factory overhead
Beginning RM Inventory 16,960 Indirect materials used 174,300
Rm Purchases (on credit) 452,100 Indirect labor used 95,700
Direct material used 247,620 other overhead costs 186,550
Indirect materials used 174,400 Total overhead incurred 456,550
Ending RM Inventory 47,040
Factory Payroll Factory overhead (Applied at180%DL 467,730)
Direct Labor used 259,850 Direct Labor used 259,850
Indirect Labor used 95,700 overhead applied 467,730
Total payroll 355,550 total conversion 727,580
Units Costs
Beginning WIP 5,200 Beginning WIP- DM 12900
Started into production 20,300 Beginning WIP conversion 27,100
Ending WIP 4,500 Total 40,000
Ending WIP DM added-247,620
90 percent complete with respect to direct Conversion added- 727,580
Materials Total costs- 1,015,200
40 percent complete with respect to
conversion
In: Accounting