Studyportal

Question 1

Based on one scenario – it can be at your workplace or business (self or friends). This scenario could be related to delivery, financial, documentation, process improvements, organization, 5S, communication and others.

 Explain the current situation where data analytics has been effectively
used.
Show a few examples where possible, supported by data, dashboard, and
visuals.
In addition, identify one gap for future improvements.
(Note: You may use mockup data as references)

Question 2

Production planning requires responsive supply replenishment to demand
changes. This is especially acute in manufacturing or service industry adopting
build to stock business model. It’s a challenging task to analyze demand patterns and strategize supply schedules.

The following scenario indicates a supply-demand situation for company’s build to stock business model. Your task is to analyze and evaluate the current
demand-supply. You will propose a solution based on your analysis.

a) Based on the situation below, analyze the demand pattern. You may use 3
weeks moving average and visualize into line graphs. Comment on the trend.

b) Based on the Q1 demand-supply schedule, comment if the production
managed to fully support all demand timely. You may restructure the table.

c) The production executive has decided to replan the entire schedule in Q2.
Additional information.

i) Assuming that by end W13, after realizing the production hiccups, the
production has ordered additional 50 units to clear backlog.
ii) Demand forecasting can never be accurate. Hence the production
executive used the previous quarter’s 3 weeks moving average as
baseline for Q2.
iii) The production planner intends to keep weekly 5 units of safety stock.
iv) Demand for Q2 is based on the schedule below.

How should the production executive analyze the production schedule and
replan accordingly. You may tabulate your demand-supply into appropriate
table that indicates:

 Inventory on hand.
 Supply-demand schedule.
Net requirement
 Required safety stock.

The output should be a replan schedule into an appropriate table commonly
known as Master Production Schedule. Comment on your schedule.

Question 3

Soon, the production executive realized demand has increased consistently over the quarters. There is a need to reevaluate either to build another production line or outsource a few % of internal production schedule. The information is given below. There is an associate with the probability of economic condition as demand remain volatile to each option and the estimated returns. The table below shows the details.

Based on the above information, help the production executive to make a good decision.
Your answers should contain:
1. A decision tree.
2. Analysis of Estimated Monetary Value
3. Conclusion

The post BMG323/03: It can be at your workplace or business (self or friends)-This scenario could be related to delivery, financial, documentation: Business Analytics, Assignment 3, WOU, Malaysia appeared first on Malaysia Assignment Help.