Description: Renata owns a local bakery store that produces and sells cakes, pies, and cookies. She determined that collectively, she has a design capacity of 200 units (combination of cakes, pies, and cookies) per day but an effective capacity of 150 units per day. She is now in the middle of a busy holiday season, and her daily output has been running at 175 units per day. Compute her design and effective capacity utilization measures. What can she conclude about her utilization?

Format: This assignment is meant to be completed using a spreadsheet. You may submit it as an Excel file, though you may copy and paste your spreadsheet into the Word document and submit it that way if you prefer. Submit this assignment here.