Question

Shared Service Department Problem Set

Yellow Springs Manufacturing produces machine parts on a job-order basis. Most business is obtained through bidding. Most firms competing with Yellow Springs bid full cost plus a 20 percent markup. Recently, with the expectation of gaining more sales, Yellow Springs reduced its markup from 25 percent to 20 percent. The company operates two service departments and two producing departments. The budgeted costs and the normal activity levels for each department are as follows:

	Service Departments		Producing Departments
	A	B	C	D
Overhead costs	$100,000	$200,000	$100,000	$50,000
Number of employees	8	7	30	30
Maintenance hours	2,000	200	6,400	1,600
Machine hours	--	--	10,000	1,000
Labor hours	--	--	1,000	10,000

The direct costs of Department A are allocated on the basis of employees; those of Department B are allocated on the basis of maintenance hours. Departmental overhead rates are used to assign costs to products. Department C uses machine hours, and Department D uses labor hours.

The firm is preparing to bid on a job (Job K) that requires three machine hours per unit produced in Department C and no time in Department D. The expected prime costs per unit are $67.

Required:

1. Allocate the service costs to the producing departments using the direct method.
2. Calculate the bid for Job K if the direct method is used.
3. Allocate the service costs to the producing departments using the sequential method. Rank the service departments based on amount of direct costs.
4. Calculate the bid for Job K if the sequential method is used.
5. Allocate the service costs to the producing departments using the reciprocal method. Use the ROUND function n Excel to set the allocation rate to 4 digits, except for the allocation from Department A to the two Producing Departments – set those to 5 digits. Use whole dollars for the fully allocated intraservice department amounts (the solutions to the linear equations), but do NOT use the ROUND function here!
6. Calculate the bid for Job K if the reciprocal method is used. Use the ROUNDUP function for the final bid amount.

Joint Costs Problem Set

Pandemic Pharmaceutical Company purchases a material that is then processed to yield three chemicals: anarol, estyl, and betryl. In June, PPC purchased 10,000 gallons of the material at a cost of $250,000, and the company incurred joint conversion costs of $70,000. June sales and production information are as follows:

	Gallons Produced	Price at Split-Off	Further Processing Cost per Gallon	Eventual Sales Price
Amarol	2,000	$55
Estyl	3,000	40
Betryl	5,000	30	$5	$60

Amarol and estyl are sold to other pharmaceutical companies at the split-off point. Betryl can be sold at the split -off point or processed further and packaged for sale as an asthma medication.

Required:

1. Allocate the joint costs to the three products using:
   1. The physical units method
   2. The sales-value-at-split-off method (Use =ROUND to round allocation ratios to 5 digits)
   3. The net realizable value method (Use =ROUND to round allocation ratios to 5 digits, except for Betryl — use =ROUNDUP for that ratio to get your check figures)
   4. The constant gross margin percentage method (use =ROUND to 4 decimal places on the GM%. There will be a rounding error of $23 in the final total check figure.)

Please Show work/ Explanations.

Answer 1

Due to character limit I am attaching the image for Pandemic Pharma.

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!

Yellow Springs
Direct Method	Dept. A	Dept. B	Dept. C	Dept. D	Total
Number of Employees			30.00	30.00	60.00
Number of Employees %			50.00%	50.00%	100.00%
Maintenance Hours			6,400.00	1,600.00	8,000.00
Maintenance Hours %			80.00%	20.00%	100.00%
Overhead costs	100,000.00	200,000.00	100,000.00	50,000.00	450,000.00
Dept. A cost to be allocated- Number of Employees %	(100,000.00)		50,000.00	50,000.00	-
Dept. B cost to be allocated- Maintenance Hours %		(200,000.00)	160,000.00	40,000.00	-
Total cost after allocation	-	-	310,000.00	140,000.00	450,000.00
Machine/ Labor Hours			10,000.00	10,000.00
Predetermined overhead rate			31.00	14.00

Bid for Job K	Amount $
Machine Hours in Dept. C	3.00
Predetermined overhead rate	31.00
Overhead per unit	93.00
Prime costs	67.00
Bid for Job K	160.00

Step Method	Dept. A	Dept. B	Dept. C	Dept. D	Total
Maintenance Hours	2,000.00		6,400.00	1,600.00	10,000.00
Maintenance Hours %	20.00%	0.00%	64.00%	16.00%	100.00%
Overhead costs	100,000.00	200,000.00	100,000.00	50,000.00	450,000.00
Dept. B cost to be allocated- Maintenance Hours %	40,000.00	(200,000.00)	128,000.00	32,000.00	-
Total cost after allocation	140,000.00	-	228,000.00	82,000.00	450,000.00
Number of Employees			30.00	30.00	60.00
Number of Employees %			50.00%	50.00%	100.00%
Dept. A cost to be allocated- Number of Employees %	(140,000.00)	-	70,000.00	70,000.00	-
Total cost after allocation	-	-	298,000.00	152,000.00	450,000.00
Machine/ Labor Hours			10,000.00	10,000.00
Predetermined overhead rate			29.80	15.20

Bid for Job K	Amount $
Machine Hours in Dept. C	3.00
Predetermined overhead rate	29.80
Overhead per unit	89.40
Prime costs	67.00
Bid for Job K	156.40

Reciprocal Method	Dept. A	Dept. B	Dept. C	Dept. D	Total
Number of Employees		7.00	30.00	30.00	67.00
Maintenance Hours	2,000.00		6,400.00	1,600.00	10,000.00
Number of Employees %	0.0000%	10.4478%	44.77612%	44.77612%	100.00%
Maintenance Hours %	20.0000%	0.0000%	64.0000%	16.0000%	100.00%
Overhead costs	100,000.00	200,000.00	100,000.00	50,000.00	450,000.00

Let cost of Dept. A is $ X and Dept. B is $ Y

So, X= 100000+ 20% of Y

So, X= 100000+ 0.20Y

Y= 200000+ 10.45% of X

Y= 200000+ 0.1045X

Substituting the value of X in equation 2:

Y = 200000 + 0.1045(100000 + 0.2Y)

Y = 200000 + 10448+.0209Y

Y – 0.0209Y = 200000+10448

0.9791044 = 210,448

Y = 210,448/0.9791044

Y = $ 214,939

Substituting the value of Y in equation 1:

So, X= 100000+ 0.2Y

So, X= 100000+ 0.2*214939

So, X= 100000+ 42988

X= $ 142,988

Allocation Summary	Dept. A	Dept. B	Dept. C	Dept. D	Total
Number of Employees %	0.000000%	10.447800%	44.776120%	ekkarill92 Next > < Previous Related Solutions Ross manufacturing produces machine parts on a job order basis. Ross gets orders after winning bidding.... Ross manufacturing produces machine parts on a job order basis. Ross gets orders after winning bidding. The bidding price is based on full cost with a 20% markup. This company has two service departments, A and B, and two production departments, C and D. The following table provides departmental information. Service Departments Production Departments A B C D Direct Costs $100,000 (total operating) $200,000 (total operating) $200,000 (overhead) $150,000 (overhead) Number of Employees 8 9 35 45 Maintenance Hours 2000... Vines Ltd produces custom machine parts on a job order basis. The company has two direct... Vines Ltd produces custom machine parts on a job order basis. The company has two direct product cost categories: direct materials and direct labour. In the past, indirect manufacturing costs were allocated to products using a single indirect cost pool, allocated based on direct labour hours. The indirect cost rate was $115 per direct labour hour. The managers of Vines Ltd decided to switch from a manual system to software programs that release materials and signal machines when to begin... Samples of 36 parts are taken from a manufacturing process that produces machine parts with a... Samples of 36 parts are taken from a manufacturing process that produces machine parts with a mean diameter of 12.40 cm and a standard deviation of 0.06 cm. If the diameters are normally distributed, what proportion of sample means will have diameters between 12.39 and 12.41 cm? Hershey Company uses a job order costing system and applies manufacturing overheads on the basis of... Hershey Company uses a job order costing system and applies manufacturing overheads on the basis of direct labor cost. Total manufacturing overhead was estimated to be $142,595 for the year; direct labor was estimated to total $150,100. (1/1) (12/31) Raw Materials Inventory $ 14,200 $ 9,400 Work in Process Inventory $ 20,000 $ 22,700 Finished Goods Inventory $ 42,500 $ 31,300 The following transactions have occurred during the year. Raw materials purchases $ 111,000 Direct materials used $ 104,500 Direct... Garcia Manufacturing uses a job order costing system and applies overhead to production on the basis... Garcia Manufacturing uses a job order costing system and applies overhead to production on the basis of direct labour hours. In 2013, costs and production data were estimated to remain the same as 2012 with total manufacturing overhead costs estimated to be $1,050,000, direct labour costs estimated to be $35 an hour, and direct labour hours to be 20,000. On January 1, 2013, Job No. 50 was the only job in process. The production data incurred prior to January 1... Garcia Manufacturing uses a job order costing system and applies overhead to production on the basis... Garcia Manufacturing uses a job order costing system and applies overhead to production on the basis of direct labour hours. In 2013, costs and production data were estimated to remain the same as 2012 with total manufacturing overhead costs estimated to be $1,050,000, direct labour costs estimated to be $35 an hour, and direct labour hours to be 20,000. On January 1, 2013, Job No. 50 was the only job in process. The production data incurred prior to January 1... Hershey Company uses a job order costing system and applies manufacturing overheads on the basis of... Hershey Company uses a job order costing system and applies manufacturing overheads on the basis of direct labor cost. Total manufacturing overhead was estimated to be $142,595 for the year; direct labor was estimated to total $150,100. (1/1) (12/31) Raw Materials Inventory $ 14,200 $ 9,400 Work in Process Inventory $ 20,000 $ 22,700 Finished Goods Inventory $ 42,500 $ 31,300 The following transactions have occurred during the year. Raw materials purchases $ 111,000 Direct materials used $ 104,500 Direct... Curtis Inc. uses a job order costing system. Manufacturing overhead is applied on the basis of... Curtis Inc. uses a job order costing system. Manufacturing overhead is applied on the basis of direct labor cost. Total manufacturing overhead was estimated to be $60,680 for the year; direct labor was estimated to total $151,700. Raw Materials Inventory (1/1) $ 10,700 (12/31) $ 13,700 Work in Process Inventory (1/1) $ 23,900 (12/31) $ 18,500 Finished Goods Inventory (1/1) $ 34,100 (12/31) $ 40,000 The following transactions have occurred during the year. Raw materials purchases $ 107,000 Direct materials... Weinrich Manufacturing uses a job order cost system and applies overhead to Production on the basis... Weinrich Manufacturing uses a job order cost system and applies overhead to Production on the basis of direct labor hours. On January 1, 2016, Job No. 25 was the only job in process with total costs of $25,000. Estimated overhead costs are $480,000, direct labor costs are $300,000 and direct labor hours are 20,000 for the year. a. Calculate the predetermined overhead rate. b. Prepare the following entries: 1. Purchased raw materials of $50,000 on account. 2. Incurred factory labor... Ecola Company uses a job order costing system. Manufacturing overhead is applied on the basis of... Ecola Company uses a job order costing system. Manufacturing overhead is applied on the basis of direct labor cost. Total manufacturing overhead was estimated to be $142,560 for the year; direct labor was estimated to total $162,000. (1/1) (12/31) Raw Materials Inventory $ 13,800 $ 10,800 Work in Process Inventory $ 29,800 $ 22,800 Finished Goods Inventory $ 41,800 $ 32,800 The following transactions have occurred during the year. Raw materials purchases $ 138,000 Direct materials used $ 75,600 Direct... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Describe how foreign keys impact the ability to add or delete rows from a table or... A pension fund manager is considering three mutual funds. The first is a stock fund, the... As a network manager in a medium-size corporation, it is your responsibility to use a proactive... When it comes to language within various cultures what is a good point or idea that... Dr. Lillian​ Fok, a New Orleans​ psychologist, specializes in treating patients who are agoraphobic​ (i.e., afraid... A box contains N identical gas molecules equally divided between its two halves. For N =... Discuss other systems and their artifacts we might find. This class revolves around a traditional computer.... ADVERTISEMENT About @ 2020 WizEdu