Question
In: Accounting
Assume that Product Z is made up of one unit of A and five units of...
Assume that Product Z is made up of one unit of A and five units of B. A is made of three units of C and four units of D. D is made of two units of E. The demand for Z is 500 units in Week 8 and 500 units in Week 10. For Z, A, C, and D, there are no units on hand, no safety stock, and no units allocated. Item E has 900 units on hand, with a safety stock of 300 units and no units allocated. Item B has 400 units on hand, 200 units of safety stock and 200 units already allocated. There are 200 units of Item C currently scheduled to arrive in Week 1 and 200 units of item D are scheduled to arrive in Week 1.
|
Week |
6 |
7 |
8 |
9 |
10 |
|
Demand |
-- |
-- |
500 |
-- |
500 |
Additional information is the following:
|
Item |
Z |
A |
B |
C |
D |
E |
|
On hand |
-- |
-- |
400 |
-- |
-- |
900 |
|
Safety stock |
-- |
-- |
200 |
-- |
-- |
300 |
|
Allocated |
-- |
-- |
200 |
-- |
-- |
-- |
|
Scheduled Receipts |
-- |
-- |
-- |
200 in Week 1 |
200 in Week 1 |
-- |
Provide the additional number of all items, including Z, that are required to meet the total demand shown for Product Z. Ignore the timing of these requirements.
please use excel solver if applicable
Solutions
Expert Solution
| Product Z | Requires 1 unit of A and 5 units of B which means for 500 units we need 500 units of A &2500 units of B | |||||||||
| A unit | Requires 3 unit of C and 4 units of D which means for 500 units of A we will need 1500units (500*3) of C and 2000 (500*4) units of D | |||||||||
| D unit | Requires 2 units of E which means for 2000 units of D we would need 4000 units (2000*2) | |||||||||
| Qty needed | 500 | 500 | 2500 | 1500 | 2000 | 4000 | ||||
| Item | Z | A | B | C | D | E | ||||
| On hand | 400 | 900 | ||||||||
| Safety stock | 200 | 300 | ||||||||
| Allocated | 200 | |||||||||
| Scheduled | 200 in week1 | 200 in week1 | ||||||||
| Actual Qty needed for week8 | 500 | 500 | 1900 | 1300 | 1800 | 2800 | ||||
| Week 10 | 500 | 500 | 2500 | 1500 | 2000 | 4000 | ||||
| Please Note | ||||||||||
| 1 | IT is asssumed that the allocated stock is for the product Z itself | |||||||||
| 2 | We would need safety stock in hand hence while calculating the actual stock required that is excluded | |||||||||
| 3 | Actual Qty required is calculated after removing the on hand, allocated and scheduled stock | |||||||||
| 4 | Week 10 it is assumed that there is no in hand , allocated abd scheduled stock | |||||||||
ekkarill92 answered 1 year agoRelated Solutions
Assume that Product Z is made of two units of A and three units of B....
Assume that Product Z is made of two units of A and three units of
B. A is made of three units of C and four of D. D is made of two
units of E
Lead times for purchase or
fabrication of each unit to final assembly are: Z takes two weeks;
A, B, C, and D take one week each; and E takes three weeks.
Fifty two units of Product Z are
required in Period 10. (Assume that...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and
two units of D. B is composed of two units of E and one unit of D.
C is made of one unit of B and two units of E. E is made of one
unit of F. Items B, C, E, and F have one-week lead times; A and D
have lead times of two weeks. Assume that lot-for-lot (L4L) lot
sizing is...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and
two units of D. B is composed of two units of E and one unit of D.
C is made of one unit of B and two units of E. E is made of one
unit of F.
Items B, C, E, and F have one-week
lead times; A and D have lead times of two weeks.
Assume that lot-for-lot (L4L) lot
sizing is...
One unit of A is made of two units of B, three units of C, and...
One unit of A is made of two units of B, three units of C, and two
units of D. B is composed of one unit of E and two units of F. C is
made of two units of F and one unit of D. E is made of two units of
D. Items A, C, D, and F have one-week lead times; B and E have lead
times of two weeks. Lot-for-lot (L4L) lot sizing is used for...
A diversified financial conglomerate has five units (subsidiaries). One unit conduct thrift operations; the second unit...
A diversified financial conglomerate has five units
(subsidiaries). One unit conduct thrift operations; the second unit
conducts consumer finance operations; the third, mutual fund
operations; the fourth, securities operations; and the fifth,
insurance operations. As a financial analyst for the conglomerate;s
holding company, you have been asked to assess all of the units and
to indicate how each unit will be affected as economic conditions
change as well as which units will be most affected.
In the past few months,...
Gillman Co. is forecasting sales of 61,400 units of product for August. To make one unit...
Gillman Co. is
forecasting sales of 61,400 units of product for August. To make
one unit of finished product, 4 pounds of raw materials are
required. Actual beginning and desired ending inventories of raw
materials and finished goods are:
August 1
(Actual)
August 31
(Desired)
Raw materials
(pounds)
74,100
68,100
Finished goods
(units)
5,100
8,420
Required:
a.
Calculate the number of units of
product to be produced during August.
b.
Calculate the number of pounds
of raw materials to...
Hickory Company manufactures two products—13,000 units of Product Y and 5,000 units of Product Z. The...
Hickory Company manufactures two products—13,000 units of
Product Y and 5,000 units of Product Z. The company uses a
plantwide overhead rate based on direct labor-hours. It is
considering implementing an activity-based costing (ABC) system
that allocates all of its manufacturing overhead to four cost
pools. The following additional information is available for the
company as a whole and for Products Y and Z:
Activity Cost Pool Activity Measure
Estimated Overhead Cost Expected Activity
Machining Machine-hours $
242,400 12,000 MHs...
Hickory Company manufactures two products—14,000 units of Product Y and 6,000 units of Product Z. The...
Hickory Company manufactures two products—14,000 units of
Product Y and 6,000 units of Product Z. The company uses a
plantwide overhead rate based on direct labor-hours. It is
considering implementing an activity-based costing (ABC) system
that allocates all of its manufacturing overhead to four cost
pools. The following additional information is available for the
company as a whole and for Products Y and Z:
Activity Cost Pool Activity Measure
Estimated Overhead Cost Expected Activity
Machining Machine-hours $
200,000 10,000 ...
Greenwood Company manufactures two products—13,000 units of Product Y and 5,000 units of Product Z. The...
Greenwood Company manufactures two products—13,000 units of
Product Y and 5,000 units of Product Z. The company uses a
plantwide overhead rate based on direct labor-hours. It is
considering implementing an activity-based costing (ABC) system
that allocates all of its manufacturing overhead to four cost
pools. The following additional information is available for the
company as a whole and for Products Y and Z:
Activity Cost Pool
Activity
Measure
Estimated Overhead
Cost
Expected
Activity
Machining
Machine-hours
$
231,600
12,000
MHs...
Greenwood Company manufactures two products—13,000 units of Product Y and 5,000 units of Product Z. The...
Greenwood Company manufactures two products—13,000 units of
Product Y and 5,000 units of Product Z. The company uses a
plantwide overhead rate based on direct labor-hours. It is
considering implementing an activity-based costing (ABC) system
that allocates all of its manufacturing overhead to four cost
pools. The following additional information is available for the
company as a whole and for Products Y and Z:
Activity Cost Pool
Activity
Measure
Estimated Overhead
Cost
Expected
Activity
Machining
Machine-hours
$
231,600
12,000
MHs...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A pub opens its door for business at 6:00 PM. From 6:00 P.M. to 8:00 P.M....
- Discussion 2 - An Integrative Approach to Psychopathology: Can you think of any cases of psychopathology...
- (1) Define attribute sampling and discuss why tests of controls tend to be attribute samples. (2)...
- What do you think is behind the emotion of jealousy? Why are some people more prone...
- A 1.78-kg block slides with a speed of 0.955 m/s on a frictionless horizontal surface until...
- A card is drawn from a standard deck of 52 cards. Find the probability that the...
- Think of an organization are familiar and answer the following questions: 1) As a consultant for...
ADVERTISEMENT