Enterprise Resource Management
Order Description
Use the Excel to solve all eight problems list on the final page.SHOW ALL THE PROCESS AND CALCULATES IN ORDER TO GET THE CREDIT.
Free Online OCR
Home
OCR API
Contact us
Free Online OCR Convert JPEG, PNG, GIF, BMP, TIFF, PDF, DjVu to Text
Select pages from 1 to 8
Recognition language(s) (you can select multiple)
Rotate image 0° CCW 90° 180° CW 90°
Page layout analysis – split multi-column text into columns
Page
of 8
Download
Copy to Clipboard
Google Translate
Bing Translator
Paste Online
Edit Online
MGMT 4640 Case Study
Spring 2013
(Rev B)
1 I P a g e
Download
Google Translate
Bing Translator
Edit Online
MGMT 4640 Case Study
Spring 2013
(Rev B)
1|Page
Maxi-TV is one of the last flat panel TV manufacturers based in America. They currently
produce two large flat screen LCD (liquid crystal display) television models, the Deluxe model
(Top Assembly Part Number 1000, abbreviated as T/A PN 1000) and the Standard model (Top
Assembly Part Number 1001). The Deluxe model and the Standard model share the same
chassis and many common components.
The Deluxe model has special software that enhances the picture quality, a DVD player (PN
3005) integrated into the side of the TV, and a brighter backlight (PN 2200) for a brighter
picture. The Standard model is similar to the Deluxe model, but without the DVD player. It
uses the same backlight technology with fewer CCFL light tubes (PN 3400). It also does not
have multiple inputs for other video devices and computers, so the Switch Module and
Switching Module (PN 3310 and PN 3004) are not required. Basically, the Standard model is the
Deluxe model with components removed.
A front view of the Deluxe model (PN 1000) appears on the next page, Page 3. A rear view of
the product also appears on the next page, but with the back case removed –thus revealing the
internal components, which are labeled in the picture. The assemblies and components
correspond to the BOM trees on Page 4.
Based on the BOM trees and the data presented in Parts 1 through 4 on Pages 5 through 7,
develop the MDS, RCCP, MRP, and CRP per the instructions. Answer the questions on the last
page based on your results. Include hard copy printouts of your spreadsheets per the
instructions when submitting your case report.
Work in teams with a minimum of 2 and maximum of 3 students per team. Each team will
submit ONE report collectively. The name of each team member must appear on the front
page with names spelled as they appear on Black Board.
Grading Criteria:
1.
2.
3.
4.
Presentation (professionalism, appearance, spelling, grammar, completeness)
Correct approach and numeric results
Proper assessment of results and overall quality of final answers
Demonstrated effort
Good Luck!
Case is DUE on the day of the final.
2|Page
15%
40%
40%
05%
MAXI-TV, Deluxe Model
(Front view of Deluxe model from Finished Goods Inventory.)
(Rear view of Deluxe model with rear panel of housing case removed.)
PART 1
Given the aggregate forecast and the booked sales orders, develop the consumed forecast and
the MDS using the appropriate Excel model. Include a printout of all relevant worksheets when
submitting your results. (Note: Round all results to the nearest whole number.) Highlight the
results with Yellow (Black text in a Yellow cell using a color printer OR mark manually using a
highlighter).
The aggregate 2013 forecast:
Month
July
Aug
PART 2
Sales and Marketing reviewed your results in Part 1 and realized that a significant number of
pending orders were not entered into the system since the person at the Order Entry desk was
on an extended vacation when you ran Part 1. The revised MDS for July 2013 appears below. .
Based on the updated MDS and the capacity information given below, run a Rough Cut Capacity
analysis for July using the appropriate model. Highlight the capacity utilization results with
Yellow (Black text in a Yellow cell using a color printer OR mark manually using a highlighter).
Master Demand Schedule (MDS)
Work days per week
Work hours per day
5|Page
CAPACITY DATA
Department A — Final Assembly
Labor resource available (Maxi-lab)
Machine resource available (Maxi-mch)
16
15
Resources required for P/N 1000
Labor resource (Maxi-lab), hr
Machine resource (Maxi-mch), hr
1.0
0.5
Resources required for P/N 1001
Labor resource (Maxi-lab), hr
Machine resource (Maxi-mch), hr
0.75
0.25
PART 3
Based on the revised MDS above and the information below, determine the NET requirements
by running an MRP model. Note: The “Amount on Hand” (or On-Hand-Inventory) shall include
the safety stock and represents inventory at the beginning of the period. Highlight the net
requirement results with Yellow (Black text in a Yellow cell using a color printer OR mark
manually using a highlighter).
Description
Top Assembly, Deluxe HD TV
Top Assembly, Standard HD TV
Assembly, Deluxe, Input-Tuner-OnScreenDisplay
Assembly, Deluxe, Backlight
Assembly, Standard, Input-Tuner-OnScreenDisplay
Assembly, Standard, Backlight
Power Supply Module
Speaker
Switch Module
DVD Module
Printed Circuit Board ASSY, ITO
Switching Module
Tuner Module
Inverter Module, Backlight
CCFL Backlight
Frame, Chasis, Metal, Universal
Case, Plastic, Universal
Reflector, Backlight, Universal
PART 4
Based on the results of your MRP, determine the capacity requirements (CRP) for Department A
only based on the table below. Highlight the net requirement results with Yellow (Black text in
a Yellow cell using a color printer OR mark manually using a highlighter).
CAPACITY DATA
Department A — Final Assembly
Labor resource available (Maxi-lab)
Machine resource available (Maxi-mch)
16
15
Resources required for P/N 1000
Labor resource (Maxi-lab), hr
Machine resource (Maxi-mch), hr
1.0
0.5
Resources required for P/N 1001
Labor resource (Maxi-lab), hr
Machine resource (Maxi-mch), hr
0.75
0.25
Department B — System Assembly
Labor resource available (01 ASSY-lab)
80
Machine resource available (01 ASSY-mch)
60
Resources required for P/N 2000
Labor resource (01 ASSY-lab), hr
Machine resource (01 ASSY-mch), hr
1.00
1.00
Resources required for P/N 2010
Labor resource (01 ASSY-lab), hr
Machine resource (01 ASSY-mch), hr
0.75
0.75
Resources required for P/N 2200
Labor resource (01 ASSY-lab), hr
1.00
Machine resource (01 ASSY-mch), hr
0.00
Resources required for P/N 2210
Labor resource (01 ASSY-lab), hr
Machine resource (01 ASSY-mch), hr
0.50
0.00
7|Page
Print out hard copies of your results from Parts 1 through 4 to include in your case submission,
and then answer the following questions:
1. Based on the forecast consumption and resulting MDS in PART 1, what can you conclude
about the progress of the sales team? If you were the head of sales, where would you
focus your sale team’s efforts (products and months)?
2. Based your results in PART 2, what is your assessment of the preliminary capacity
situation (RCCP)?
3. Determine what action(s) should be taken (if any) given the situation in PART 2?
4. Review the order policy for Part Number 3400 (backlights) with regards to the results of
your MRP. If the holding cost is $0.50 per unit per week and the order cost is $75 per
order, then what is the total cost (order and holding) of this order policy of Lot Size
1500? Determine if there is any benefit in increasing the order size to a multiple of
1500.
5. What is your assessment of the capacity requirements (CRP) based on the results of
your MRP?
6. Compare the CRP in PART 2 to the RCCP in PART 4. Explain the difference in the results.
(Reconcile the numbers!)
7. If you were the operations manager, what actions would you take to optimize the
situation in PART 4?
8. BONUS: Assess the capacity situation of DEPARTMENT B (System Assembly) based on
the results of your MRP and determine what action(s) are needed, if any.
Our Service Charter
-
Excellent Quality / 100% Plagiarism-Free
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers. -
Free Revisions
We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed. -
Confidentiality / 100% No Disclosure
We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service. -
Money Back Guarantee
If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit. -
24/7 Customer Support
We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.