Question

In: Accounting

Risk Assessment: Question 1 Analyze the risk associated with the cost of ingredients Using the data...

Risk Assessment: Question 1
Analyze the risk associated with the cost of ingredients
Using the data provided, determine the cost of each type of cupcake
Presentation matters when showing the results of data analytics, because you are trying to take many numbers and present them in a way that someone unfamiliar with your computations can quickly understand your results.  An example of one type of presentation for the cost of cupcakes is shown below.  You can use this example as a template, or come up with a better way to present your work.   If you click on the yellow cells below, you can see the formulas used in this particular visualization. It can also serve as a check to ensure that you are arriving at the correct cost when you create your cost analysis.
Hint:  There are many ways to set up a visualization, pick a way that makes sense for you.  You can copy and paste the recipes or make reference in the cells below to the original numbers on the data pages.
Vanilla Vanilla Cupcakes Butter Cream Frosting Cupcakes Total
Ingredient eggs sugar salt vanilla flour baking powder butter vanilla butter shortening confec. Sugar salt milk
Unit measured as dozen pounds pounds quart pounds pounds pounds quart pounds pounds pounds pounds gallons
Amount of unit used per 36 cupcakes 0.7500 0.9923 0.0049 0.0150 1.2375 0.0195 1.0000 0.0225 0.7500 0.6780 3.9600 0.0049 0.0473
price/unit $1.50 $0.50 $0.20 $40.00 $0.30 $3.00 $2.00 $40.00 $2.00 0.55 $0.56 $0.20 $3.00
Ingredient cost per /36 cupcakes $1.12500 $0.49613 $0.00098 $0.60000 $0.37125 $0.05850 $2.00000 $0.90000 $1.50000 $0.37290 $2.21760 $0.00098 $0.14175 $9.78508
Cost /cupcake $0.270

Solutions

Expert Solution

Determination of cost of each type of Cupcake, per unit
Particulars Source Vanilla Cup Cake Total Butter cream frosting cupcakes Total
Eggs Sugar Salt Vanilla Flour Baking powder Butter Vanilla Butter Shortening Confec.S
A Unit of Measurement Given Dozen Pounds Pounds Quarts Pounds Pounds Pounds NA Quarts Pounds Pounds Pounds NA
B Quantity required for 36 cupcakes Given 0.7500 0.9923 0.0049 0.0150 1.2375 0.0195 1.0000 4.0192 0.0225 0.7500 0.6780 3.9600 5.4105
C Ingredient Cost for 36 cupcakes Given $1.12500 $0.49613 $0.00098 $0.60000 $0.37125 $0.05850 $2.00000 $4.6519 $0.90000 $1.50000 $0.37290 $2.21760 $4.9905
D Cost of ingredients for 1 Cupcake C/36 units $0.03125 $0.01378 $0.00003 $0.01667 $0.01031 $0.00163 $0.05556 $0.1292 $0.02500 $0.04167 $0.01036 $0.06160 $0.1386
Therefore, Cost of per unit of
Vanilla Cupcake = $0.1292
Butter cream frosting cake = $0.1386

Related Solutions

Question 16 The cost of capital associated with an investment does not depend on the risk...
Question 16 The cost of capital associated with an investment does not depend on the risk of that investment. Select one: True False Question 17 Your company purchased a piece of land five years ago for $150,000 and subsequently added $175,000 in improvements. The current book value of the property is $225,000. There are two options for future use of the land: 1) the land can be sold today for $350,000 on a net after-tax basis; 2) your company can...
Risk Assessment Homework In this assignment, you will perform a qualitative risk assessment, using a template...
Risk Assessment Homework In this assignment, you will perform a qualitative risk assessment, using a template that has been provided below.    A listing of threats has been prepopulated for you. These threats have been categorized by type as shown below:                                                    Threat Origination Category Type Identifier Threats launched purposefully P Threats created by unintentional human or machine errors U Threats caused by environmental agents or disruptions E Purposeful threats are launched by threat actors for a variety of reasons...
Question 1. Choose one of the three options described below. Analyze the data using what you...
Question 1. Choose one of the three options described below. Analyze the data using what you have learned in class. Instructions: Your paper will include the following: A statement of the research question A description of the source of the data A description of the variables used in the analysis and an explanation of why you chose these variables Graphs (with clear labels) and numerical summaries to support your analysis Explanations that reflect the use of Unit 2 concepts An...
Using the Assessment 5, Part 1 Template, analyze and compute the necessary financial ratios. The Financial...
Using the Assessment 5, Part 1 Template, analyze and compute the necessary financial ratios. The Financial Statements worksheet in the template contains the income statement, balance sheets, and additional information needed. The Ratio Analysis worksheet contains space for your calculations and answers. Net sales (all on account) $600,000 $520,000 Assets Expenses: Current Assets Cost of Goods Sold $415,000 $354,000 Cash $21,000 $18,000 Selling and administrative $120,800 $114,600 Short-term investments $18,000 $15,000 Interest Expense $7,800 $6,000 Accounts Receivable $86,000 $74,000 Income...
Using the risk management process each student is to perform a Risk Assessment on a vocational...
Using the risk management process each student is to perform a Risk Assessment on a vocational area of their choice. This may be a department within the college, a business structure they are aware of, or any other vocational area. The student is to use the forms developed in risk management task, and submit them to you (the assessor) at the conclusion of their review As part of this task, each student is to record: - who was involved in...
Explain the contributions of benefit/cost analysis, environmental assessment, and risk assessment to administrative decision-making.
Explain the contributions of benefit/cost analysis, environmental assessment, and risk assessment to administrative decision-making.
Make a Project of Management Risk Assessment: 1. Make a Qualitative Risk assessment 2. Make Quantitative...
Make a Project of Management Risk Assessment: 1. Make a Qualitative Risk assessment 2. Make Quantitative Risk Assessment and Mitigation
analyze the key risk areas associated with an audit of Lincoln Federal Savings and Loan. Next,...
analyze the key risk areas associated with an audit of Lincoln Federal Savings and Loan. Next, recommend at least two (2) risk areas that should be included in the audit plan. Provide a rationale to support your recommendation.
What is management’s assessment of Starbucks risk associated with interest rates, changing prices and self insurance?
What is management’s assessment of Starbucks risk associated with interest rates, changing prices and self insurance?
to critically analyze some of the problems associated with basing depreciation expenses on cost model and...
to critically analyze some of the problems associated with basing depreciation expenses on cost model and detrimental impact of fair value based revaluation model.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT