Q 3

Question 2 has info on Cozy Eatery

you want cozy eat info, its found in Q2 as attsched below

you can use the statistic in Q2 only to ans Q3

Question 3 (a) Relate one method which Cozy Eatery can adopt to increase its F&B business customer base in each of the following departments with reference to your experience in running a virtual company in MonsoonSIM: (b) (i) Retail, (ii) B2B, (iii) Marketing (10 marks) Business environment is always competitive. Innovative organisations succeed not by imitation but by re-invention. Outline plans for Cozy Eatery to harnesses innovation to design two new products or services for its F&B business. You may refer to Enterprise Singapore's Business Excellence Framework on Process Innovation. Write based on your own creativity, research or apply innovations from any industry to Cozy Eatery. (Note 1: Limit your answer to 500 words for both parts). (Note 2: In-text citations are required if references are made to books, articles or websites. Use APA-style references.) (10 marks) Question 2 One of the popular items in Cozy Eatery's menu is a cake which it buys from Tasty Bakery. The cost depends on the total quantity of weekly order as shown below: Total Quantity of Weekly Order Cost per piece Less than 300 pcs $3.30 300 pcs to 499 pcs $3.00 500 pcs or more $2.70 Tasty also charges a weekly delivery fee of $70, regardless of the quantity ordered and number of delivery trips made in the week For example, if the order quantity is 520 pieces, then the total cost = $70 + 520 pcs * $2.70/pcs. Cozy Eatery is evaluating whether it should make the cake itself. It will have to employ a part time baker who is able to produce the cake with equivalent quality. While the equipment cost is considered sunk cost, the baker's salary and equipment maintenance cost will be $600 per week. The variable cost for each piece of cake will be $1.80. (a) Create a model to help Cozy Eatery to decide whether to make or buy the cake. Refer to the table below, you shall start from 250 pieces of cakes in the first column and increment in steps of 10 pieces per row, up to 650 pieces. Cells in other columns must contain Excel formulae and/or functions without simple linking to another cell You must illustrate conditional formatting to highlight the cell in the Make column with Green background if "make" is the cheaper option. Do likewise for the cell in the Buy column by highlighting it in Yellow background, if buy is the cheaper option. Total Cost (SS) Make Buy Minimum Best Option Weekly Quantity of Cake 250 Buy The first row for 250 pieces is shown for reference. Question 2 One of the popular items in Cozy Eatery's menu is a cake which it buys from Tasty Bakery. The cost depends on the total quantity of weekly order as shown below: Total Quantity of Weekly Order Less than 300 pcs 300 pcs to 499 pcs 500 pcs or more Cost per piece $3.30 $3.00 $2.70 Tasty also charges a weekly delivery fee of $70, regardless of the quantity ordered and number of delivery trips made in the week For example, if the order quantity is 520 pieces, then the total cost = $70 + 520 pcs * $2.70/pcs. Cozy Eatery is evaluating whether it should make the cake itself. It will have to employ a part time baker who is able to produce the cake with equivalent quality. While the equipment cost is considered sunk cost, the baker's salary and equipment maintenance cost will be $600 per week. The variable cost for each piece of cake will be $1.80