Question
Would you please help me with this assignment it is due in 4 hours! Thank you so much in advance!! For this case study, you
Would you please help me with this assignment it is due in 4 hours! Thank you so much in advance!! For this case study, you will analyze cost information for Sweet Tooth Candies, a bulk candy store that will let its customers mix-and-match their selection of candies. All candy will be sold at a uniform price. Your task is to help the manager determine this single price per pound.Introduction Rashed just bought a self-serve candy business. This shop, SweetTooth Candies, serves a large variety of candies, including chocolates, hard candies, jelly beans and gummies. The customer fills an empty bag with their choice of candies and then it is weighed at the checkout. All candies are sold for the same price per pound to customers. Rashed needs to decide how much to charge for each pound of product. However, he has discovered that determining this answer is not so easy because many of the candies have different costs. Based on his initial orders and invoices, Rashed has gathered data on the costs and weights of the products he stocks. Several of the candies have the same costs, so he has grouped them together into types. Refer to the "candycost" worksheet of the data file for this information. Next, Rashed knows that he cannot just take an average price of the candies. Instead, he invites 25 family and friends to the shop just prior to its opening and tells them to get themselves whatever they would like. Rashed weighs each ingredient they put into their bag, so he knows exactly how much of each type of candy each person chooses. The details of these measurements are shown in the "candydata" worksheet of the data file provided. Deliverables: Perform the necessary analysis and research to answer the following set of questions. The output must be a professional looking report and an Excel spreadsheet. Remember to format all values to the appropriate number of decimal places. Add column labels to organize and present you calculations. Use formulas to do all your calculations, and do not change them into values (I should be able to check your formulas and calculations). Preliminary questions These are provided for your guidance. You do not need to include your answers to these questions in your report. 1) Explain why Rashed cannot just average the costs of the different types of candies in order to determine his average cost per pound. 2) If two bags filled by customers both weighed 1 pound exactly, would they both have the same cost to Rashed? Why or why not? Initial Calculations3) Refer to the "candycost" worksheet that shows all of the cost and weight data. Calculate how much each of the items costs per pound. Present results in new column labeled "Cost Per Pound." 4) Determine how much each plastic bag and twist tie cost Rashed. While he will assume the weight of the bag and tie are negligible, Rashed wants their purchase cost factored into the cost of each order. Do these calculations in Excel, labeled as "Cost Per Unit". 5) The sample data for the 25 observations are shown in the worksheet "candydata." For each of these observations, determine the total weight of the observation. Do these calculations in Excel in a column labeled "Total Weight". 6) Also in Excel, calculate the total cost of each of the 25 sample orders. Remember to add in the cost of the plastic bag and twist tie in addition to the cost of the candies. Do these calculations in Excel in a column labeled "Total Cost". You may add other columns as required; please provide appropriate column labels. Cost Analysis 7) Calculate the cost per pound for each customer order. Also calculate the average cost per unit of weight for the entire sample. 8) Interpret the results in terms of what Rashed should do. What should he consider as an average cost per pound of the bag and its ingredients, based on the sample data? Conclusions & Recommendations 9) Should Rashed charge customers his average cost per pound? Why or why not? 10) Do some informal, online research for bulk candy stores of this type (e.g. Sweet Factory, Fuzziwigs, etc.). What do similar franchises charge per pound? 11) Compare Rasheds cost per pound to what is charged per pound at similar candy shops. Assuming Rashed charged a similar price, what would his percent markup be? 12) Discuss the markup. Include considerations or reasons that Rashed might want to charge prices similar to his competitors, even given his cost per pound.
Table 1: "candycost" dataset | |
Component | Bulk Cost |
Cholocate covered nuts | $12.96 / 2 U.S. lbs |
Gourmet jelly beans | $24.50 / 5 U.S. pounds |
Gummy candies | $13.50 / 5 U.S. pounds |
Sour hard candies | $16.50 / 5 U.S. pounds |
Individually wrapped candies | $14.99 / 5 U.S. pounds |
M&Ms, Skittles, Reeses pieces, etc. | $156.50 / 25 U.S. pounds |
Plastic bags to hold candy | $35 / 1000 bags |
Twist ties to secure bags closed | $ 10 / 2000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started