group of 6 I want 30 slides
ACC 601-70-H419
Don't use plagiarized sources. Get Your Custom Essay on
Group ppt 1
Just from $13/Page
Group Assignment 1 (80 Points)
Specific Instructions:
1. As a group, Complete this assignment in good form. Use excel or word only. Provide all supporting calculations to show how you arrived at your numbers.
2.
Add only the names of group members who participated in the completion of this assignment. Do not forget to include the participants names. If the participants names are not listed, the grade for participants will result in zero.
3. Submit only one copy of your completed work via Moodle. Do not sent it via email.
4. Due: Sunday, February 2 at 11:00 PM EST. Late submissions will not be accepted.
Part A-1: Application of Job Order Costing
“Blast it!” said David Wilson, president of Teledex Company. “We’ve just lost the bid on the Koopers job by $3,000. It seems we’re either too high to get the job or too low to make any money on half the jobs we bid.”
Teledex Company manufactures products to customers’ specifications and uses a job-order costing system. The company uses a plantwide predetermined overhead rate based on direct labor cost to apply its manufacturing overhead (assumed to be all fixed) to jobs. The following estimates were made at the beginning of the year:
Department
Fabricating
Machining
Assembly
Total Plant
Manufacturing overhead
$
355,250
$
406,000
$
91,350
$
852,600
Direct labor
$
203,000
$
101,500
$
304,500
$
609,000
Jobs require varying amounts of work in the three departments. The Koopers job, for example, would have required manufacturing costs in the three departments as follows:
Department
Fabricating
Machining
Assembly
Total Plant
Direct materials
$
3,300
$
200
$
1,700
$
5,200
Direct labor
$
3,400
$
500
$
6,500
$
10,400
Manufacturing overhead
?
?
?
?
Required:
1. Using the company’s plantwide approach:
a. Compute the plantwide predetermined rate for the current year.
b. Determine the amount of manufacturing overhead cost that would have been applied to the Koopers job.
2. Suppose that instead of using a plantwide predetermined overhead rate, the company had used departmental predetermined overhead rates based on direct labor cost. Under these conditions:
a.Compute the predetermined overhead rate for each department for the current year.
b. Determine the amount of manufacturing overhead cost that would have been applied to the Koopers job.
4. Assume that it is customary in the industry to bid jobs at 150% of total manufacturing cost (direct materials, direct labor, and applied overhead).
a.What was the company’s bid price on the Koopers job using a plantwide predetermined overhead rate?
b.What would the bid price have been if departmental predetermined overhead rates had been used to apply overhead cost?
Part A-2: Schedules of Cost of Goods Manufactured and Cost of Goods Sold; Income Statement
Superior Company provided the following data for the year ended December 31 (all raw materials are used in production as direct materials):
Selling expenses
$
216,000
Purchases of raw materials
$
264,000
Direct labor
?
Administrative expenses
$
159,000
Manufacturing overhead applied to work in process
$
368,000
Actual manufacturing overhead cost
$
355,000
Inventory balances at the beginning and end of the year were as follows:
Beginning of Year
End of Year
Raw materials
$
51,000
$
33,000
Work in process
?
$
32,000
Finished goods
$
34,000
?
The total manufacturing costs for the year were $675,000; the cost of goods available for sale totaled $735,000; the unadjusted cost of goods sold totaled $669,000; and the net operating income was $32,000. The company’s underapplied or overapplied overhead is closed to Cost of Goods Sold.
Required:
Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. (Hint: Prepare the income statement and schedule of cost of goods sold first followed by the schedule of cost of goods manufactured.)
Part B-1: Process Costing using Weighted Average
“I think we goofed when we hired that new assistant controller,” said Ruth Scarpino, president of Provost Industries. “Just look at this report that he prepared for last month for the Finishing Department. I can’t understand it.”
Finishing Department costs:
Work in process inventory, April 900 units; materials 100% complete; conversion 60% complete
$
8,561
*
Costs transferred in during the month from the
preceding department, 2,400 units
25,381
Materials cost added during the month
10,017
Conversion costs incurred during the month
21,750
Total departmental costs
$
65,709
Finishing Department costs assigned to:
Units completed and transferred to finished goods,
2,700 units at $24.340 per unit
$
65,709
Work in process inventory, April 30, 600 units;
materials 0% complete; conversion 50% complete
0
Total departmental costs assigned
$
65,709
*Consists of cost transferred in, $4,286; materials cost, $2,025; and conversion cost, $2,250.
“He’s struggling to learn our system,” replied Frank Harrop, the operations manager. “The problem is that he’s been away from process costing for a long time, and it’s coming back slowly.”
“It’s not just the format of his report that I’m concerned about. Look at that $24.340 unit cost that he’s come up with for April. Doesn’t that seem high to you?” said Ms. Scarpino.
“Yes, it does seem high; but on the other hand, I know we had an increase in materials prices during April, and that may be the explanation,” replied Mr. Harrop. “I’ll get someone else to redo this report and then we can see what’s going on.”
Provost Industries manufactures a ceramic product that goes through two processing departments—Molding and Finishing. The company uses the weighted-average method in its process costing.
Required:
1-a. Calculate the equivalent units of production.
1-b. Calculate the cost per equivalent unit.
1-c. How much cost should have been assigned to the ending work in process inventory?
1-d. How much cost should have been assigned to the units completed and transferred to finished goods?
Part B-2: Break-Even Analysis
Cheryl Montoya picked up the phone and called her boss, Wes Chan, the vice president of marketing at Piedmont Fasteners Corporation: “Wes, I’m not sure how to go about answering the questions that came up at the meeting with the president yesterday.”
“What’s the problem?”
“The president wanted to know the break-even point for each of the company’s products, but I am having trouble figuring them out.”
“I’m sure you can handle it, Cheryl. And, by the way, I need your analysis on my desk tomorrow morning at 8:00 sharp in time for the follow-up meeting at 9:00.”
Piedmont Fasteners Corporation makes three different clothing fasteners in its manufacturing facility in North Carolina. Data concerning these products appear below:
Velcro
Metal
Nylon
Annual sales volume
95,000
216,000
320,000
Unit selling price
$
1.90
$
1.30
$
0.90
Variable expense per unit
$
0.70
$
0.70
$
0.70
Total fixed expenses are $262,000 per year.
All three products are sold in highly competitive markets, so the company is unable to raise prices without losing an unacceptable numbers of customers.
The company has an extremely effective lean production system, so there are no beginning or ending work in process or finished goods inventories.
Required:
1. What is the company’s over-all break-even point in dollar sales?
2. Of the total fixed expenses of $262,000, $34,200 could be avoided if the Velcro product is dropped, $96,000 if the Metal product is dropped, and $38,800 if the Nylon product is dropped. The remaining fixed expenses of $93,000 consist of common fixed expenses such as administrative salaries and rent on the factory building that could be avoided only by going out of business entirely.
a. What is the break-even point in unit sales for each product?
b. If the company sells exactly the break-even quantity of each product, what will be the overall profit of the company?
