D E F G H 5 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem or work area as indicated. Use the SUM function with cell references to add amounts as indicated. Manufacturing time in minutes 1 Function: SUM; Formula: Add, Divide: Cell Referencing 3 E11.13 - Using Excel to Calculate Manufacturing Cycle 4 Efficiency PROBLEM 6 Peterson Papers makes personalized stationery of the highest 7 quality. The company maintains a stock of blank note cards, calling 8 cards, stationery, and envelopes. Customers order online, indicating g the product type, personalization (monogram name), font style, and 10 color. The following schedule is typical of an order of 100 calling 11 cards: 12 13 Activity Minutes 14 Process order 8 Wait for production to begin 50 Pull calling cards from inventory 10 Set up machine for font style and color 4 Print caling cards 32 Inspect cards 2 Wait for packaging 8 Package cards for shipping 4 Wait for pickup by FedEx 60 24 Calculate the manufacturing cycle efficiency Value-added time in minutes Manufacturing cycle officiency 15 16 17 18 19 20 22 23