Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello i would like to know how to calculate the required number of employees and machine on requirement A *Requirement B how to calculate Direct

image text in transcribedimage text in transcribedimage text in transcribed

hello i would like to know how to calculate the required number of employees and machine on requirement A

*Requirement B how to calculate Direct material , direct labor including fringes , indirect labor , machinery.

*requirement c how to calculate the unused labor and machine capacity cost .

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Atlanta Dairy has an ice cream plant. They prepared the following timedriven ABC analysis for Suppose that all the information is the same except for the following: forecasting resource capacity. @ (Click the icon to view the updated information.) (Click the icon to view additional data.) Requirements (a) Assuming that only full-time employees can be hired, determine the number of production employees required to meet this production plan. Also, determine the number of machines required for this production plan. (b) Prepare a proforma monthly product line income statement. (Click the icon to view the total machine hours.) (0) What are the company's gross prot and the ratio of gross profit to sales after incorporating the cost of unused capacity? (Click the icon to view the total direct labor hours.) (Click the icon to View the total indirect labor hours.) cacao (Click the icon to View the proforma product profitability.) Mm. ...au.....c..uu.a \"on. \"on. c-.. ._.... ..... Total direct labor hours Vanilla Chocolate Strawberry MochaaAimond Total Production and sales Volume (gallons) 10,500 8,900 1,600 1,000 22,000 Direct labor hours per gallon 0.03 0.03 0.03 0.03 Total direct labor hours 315.0 267.0 48.0 30.0 660.0 -@ J Cues [On ' Total machine hours Vanilla Chocolate Strawberry Mocha-Almond Total Production volume 10,500 8,900 Machine hours per 1000 gallon 8 8 Total machine run time (hours) 84.0 71.2 Number of production runs 19 15 Setup time per run (hours) Machine setup time (hours) 1,600 8 12.8 2 2.3 4.6 1,000 8 22,000 176.0 Total machine hours Additional data Atlanta Dairy's employees are available for 131 hours of work each month and have a total monthly compensation of $3,930 per employee. This results in a cost rate per employee of $30 per hour. Atlanta Dairy leases machines on a monthly basis. The lease cost for each machine is $7,440 with a total available capacity per machine line of 155 hours per month. This results in a cost rate for machines of $48 per machine hour. Close the number of 0, determine the to sales after Total indirect labor hours Vanilla Chocolate Strawberry Mocha-Almond Total # of production runs 19 15 2 3 Handle production runs (hours/run) 3.0 3.0 3.0 3.0 Indirect laborhandle runs 57.0 45.0 6.0 9.0 117.0 Setup time per run (hours) 1.9 0.7 2.3 2.9 Indirect labor hours per run 3,8 1,4 4.6 5,8 Indirect laboritotal setup hours 72.2 21.0 9.2 17.4 119.8 Indirect laborimaintain products 8'5 8'5 8'5 8'5 34'0 Total indirect labor hours 137.7 74.5 23.7 34.9 270.8 -m Pro forma product profitability (Amounts are rounded to the nearest dollar.) Vanilla Chocolate Strawberry MochaVAlmond Total Selling price 305 $ 2.80 $ 3.60 $ 4.35 $ 3.05 Sales volume 10,500 8,900 1,600 1,000 22,000 Revenues 32,025 $ 24,920 $ 5,760 $ 4,350 $ 67,055 Direct materials 5,880 4,984 12,410 Direct labor (including fringes) 9,450 8,010 1,440 19,800 indirect labor 4,131 2,235 1,047 8,124 Machinery 5,765 3,922 11,323 Gross profit 6,799 $ 5,769 $ 1,878 $ 951 $ 15,398 Gross profit (% of sales) 21.2 % 23.2 % 32.6 % 21.9 "/o 23.0 \"/0 Direct materials Direct labor (including fringes) Indirect labor Machinery ABC analysis for Suppose that all the information is the same except for the following: g (Click the icon to view the updated information.) Data table Vanilla Chocolate Strawberry Mocha-Almond Total Sales volume (gallons) 16,500 13,000 2,000 1,100 32,600 # production runs 20 18 7 4 49 . (Round all interim and final per unit calculations to the nearest cent and all other dollar amounts to the nearest whole >

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Decision Modeling Business Analytics With Spreadsheet

Authors: Nagraj Balakrishnan, Barry Render, Ralph Stair, Charles Munson

4th Edition

1501515101, 978-1501515101

More Books

Students also viewed these Accounting questions

Question

Define failure. (p. 273)

Answered: 1 week ago

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago

Question

3. To retrieve information from memory.

Answered: 1 week ago