Harootunian Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on machine-hours. The company based its predetermined overhead rate for the current year on the following data: Total machine-hours 80,000 Total fixed manufacturing overhead cost $ 312,000 Variable manufacturing overhead per machine-hour $ 2.10 Recently, Job T629 was completed with the following characteristics: Number of units in the job 50 Total machine-hours 200 The estimated total manufacturing overhead is closest to what?
In: Accounting
|
|
||||
|
The cost of the direct materials that can be used to manufacture the table are as follows. These cost are on a per unit basis. |
||||
|
Table Top |
$2,800.00 |
|||
|
Table Leg |
$1,050.00 |
|||
|
Drawer |
$480.00 |
|||
|
The company uses a job order costing system and applies manufacturing overhead to jobs based on direct labor hours. |
||||
|
The company estimates that there will be 12 direct labor hours worked during the month. |
||||
|
The estimated manufacturing overhead cost for the month is: |
||||
|
a. |
Factory supervisor salary per month |
$4,000.00 |
||
|
b. |
Rent for the factory per month |
$1,400.00 |
||
|
c. |
Depreciation of factory equipment per month |
$600.00 |
||
|
Total Estimated manufacturing overhead |
$6,000.00 |
|||
|
What is the predetermined manufacturing overhead rate? |
|
|||
|
Step 2 |
The first order you received was to manufacture a table using a table top and four legs. This is your Job #1. |
|||
|
Step 3 |
The customer that has ordered Job #2, wants a table that is the same as Job #1, but wants to also add a drawer to the table. |
|||
|
Step 4 |
The following is a list of transactions that need to be recorded for the company for activity in the month of December. Record those in the "General Journal" tab of the excel file using the proper format. Please use the following accounts: Accounts Receivables, Raw materials, Work in process, Finished goods, Accumulated depreciation, Accounts payable, Salaries and wages payable, Sales revenue, Manufacturing overhead, Cost of goods sold, Salaries and wages expense, Advertising expenses, and Depreciation expense. |
|||
|
1-Dec |
Raw Materials purchased on account, $28,000. |
|||
|
5-Dec |
All Raw Materials needed for Job #1 were requisitioned from the material storage for use during the month. Assume all materials are direct. (After you journalize this entry please enter the information into Job #1 Cost Sheet) |
|||
|
10-Dec |
The following employee costs were incurred but not paid during the month: |
|||
|
There are three assembly employees that spend 2 hours each, $30 per hour to make the table for Job #1. (After you journalize this entry please enter the information into Job #1 Cost Sheet) |
||||
|
Salary for supervisor of the factory $4,500. |
||||
|
Administrative Salary $2,000. |
||||
|
15-Dec |
All Raw Materials needed for Job #2 were requisitioned from the material storage for use during the month. Assume all materials are direct. (After you journalize this entry please enter the information into Job #2 Cost Sheet) |
|||
|
16-Dec |
Rent for the month of December for the factory building incurred but not paid $1,400. |
|||
|
17-Dec |
Advertising costs incurred but not paid for the month was $1,200. |
|||
|
20-Dec |
Depreciation for the month of December was recorded on equipment was $750 ($150 for equipment used in the factory and the remainder for equipment used in selling and administrative activities). |
|||
|
22-Dec |
Manufacturing overhead cost was applied based on direct labor hours to Job #1 based on the POHR determined on the "Job Cost Sheet". (After you journalize this entry please enter the information into Job #1 Cost Sheet) |
|||
|
26-Dec |
Job #1 was completed and transferred to Finished Goods during the month. |
|||
|
28-Dec |
The completed table from Job #1 was sold on account to the customer for $33,000 during the month. (Hint: Make sure to account for the cost of the table that was sold using the cost from the job cost sheet.) |
|||
|
31-Dec |
Direct labor cost incurred but not paid for three employees to start manufacturing Job #2. The employees only worked one hour each, three hours total, $30 per hour during the month and they did not complete their work on the job. (After you journalize this entry please enter the information into Job #2 Cost Sheet) |
|||
|
31-Dec |
Manufacturing overhead cost was applied based on direct labor hours to Job #2 based on the POHR. Only three direct labor hours were worked on Job #2 during the month. (After you journalize this entry please enter the information into Job #2 Cost Sheet) |
|||
|
31-Dec |
Any underapplied or overapplied overhead for the month was closed out to Cost of Goods Sold. |
|||
|
Step 5 |
Post the journal entries that you recorded on the "General Journal" tab to the "T-accounts" tab. This is the company's first month of business, so there will not be any beginning balances. Compute the balance for each T-account after all of the entries have been posted. |
|||
|
Step 6 |
Prepare a Schedule of Cost of Goods Manufactured and a Schedule of Cost of Goods Sold on the "Schedule of COGM and COGS" tab for Job #1 and Job #2 that were worked on during the month by the company. Make sure to follow the format noted in your book (pg. 87). (Hint: This is the company's first month of operations and therefore the beginning balances will be zero.) |
|||
|
Step 7 |
Prepare an Income Statement for the month using the Traditional Format on the "Income Statement" tab. |
|||
|
Step 8 |
Answer the additional questions below |
|||
|
Check Figure: Cost of Goods Manufactured= $10,180, Net operating income=$17,470 |
||||
|
What is the ending balance for raw materials? |
||||
|
What is the ending balance for work in process? |
||||
|
What is the ending balance for finished goods? |
||||
|
What is the actual manufacturing overhead cost incurred during December before adjustment? |
||||
|
What is the total applied manufacturing overhead cost during December before adjustment? |
||||
|
What is the unadjusted cost of goods sold? |
||||
|
Was the manufacturing overhead for the month of December overapplied/underapplied ? |
||||
|
What is the amount of Manufacturing overhead overapplied/underapplied? |
||||
|
What is the adjusted cost of goods sold? |
||||
|
What is gross margin? |
||||
|
What is the total prime cost for Job#1? |
||||
|
What is the total conversion cost for job #1? |
||||
|
What is the total product cost for job#1? |
||||
|
What was the period cost incurred for the month of December? |
||||
|
What is the total variable cost incurred for Job #1(assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)? |
||||
|
What is the contribution margin for Job #1 (assume that all selling and administrative cost and all manufacturing overhead costs are fixed.)? |
||||
|
What would be the actual (not applied) total fixed manufacturing overhead cost incurred for the company for the month if the order in Job #1 is for five tables instead of one table assuming this cost is with in the relevant range? |
||||
|
Job Cost Sheet #1 |
||||||||
|
Job Number |
Date Initiated |
|||||||
|
Item |
Date completed |
|||||||
|
Direct Matarials |
Direct Labor |
Manufacturing Overhead |
||||||
|
Amount |
Hours |
Rate |
Amount |
Hours |
Rate |
Amount |
||
|
Cost Summary |
||||||||
|
Direct Materials |
||||||||
|
Direct Labor |
||||||||
|
Manufacturing Overhead |
||||||||
|
Total Product Cost |
||||||||
|
Unit Product Cost |
||||||||
|
Job Cost Sheet #2 |
|||||||||
|
Job Number |
Date Initiated |
||||||||
|
Item |
Date completed |
||||||||
|
Direct Matarials |
Direct Labor |
Manufacturing Overhead |
|||||||
|
Amount |
Hours |
Rate |
Amount |
Hours |
Rate |
Amount |
|||
|
Cost Summary |
|||||||||
|
Direct Materials |
|||||||||
|
Direct Labor |
|||||||||
|
Manufacturing Overhead |
|||||||||
|
Total Product Cost |
|||||||||
|
Unit Product Cost |
|||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
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
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
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
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