Excel_Comprehensive_Capstone2_Summer_Revenue

Grader – Instructions Excel 2019 Project

Project Description:

In this project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a workbook for Frank Osei, the Vice President of Finance, that includes financial information and analysis regarding summer product revenue.

 

Steps to Perform:

Step Instructions Points Possible
1 Open the Excel file StudentExcel_Comp_Cap2_Summer_Revenue.xlsx downloaded with this project. 0
2 On the Maine Store worksheet, in the range B9:B16, use the Fill Series feature to enter interest rates beginning with 8.00%. Decrease the amounts by .50% ending with 4.50%. Format the rates as Percent Style with two decimal places and apply bold and center. Hint: Use the tools on the Home tab in the Font group. 4
3 In cell B8, enter a PMT function using the information in the range B2:B4 to calculate a monthly payment. Be sure that the result displays as a positive number. Hint: Use the formula =-PMT(B4/12,B3,B2) 2
4 In cells B8:H16, create a Data Table using the information in cells B2:B4 where the row input cell is the Period and the column input cell is the rate. Apply the format in B8 to the results in the data table, and then AutoFit columns C:H. Format the payment option closest to and less than $10,000 per month with the Note cell style. Change the Orientation to Landscape. Hint: Use the tools on the Data tab in the Forecast group. 4
5 On the Quarterly Apparel Costs worksheet, apply the Currency [0] cell style to the range B6:E6. Apply the Comma [0] cell style to the range B7:E17. To the range B18:E18, apply the Currency [0] and Total cell styles. Hint: Use the tools on the Home tab in the Styles group. 2
6 Name the ranges B6:E10 Swim_Costs; B11:E14 Shirt_Costs; B15:E16 Jacket_Costs; and B17:E17 Hats_Costs. Hint: Use the tools on the Formula tab in the Defined Names group. 2
7 Insert a new row 15. In cell A15, type Go Explore Shirts. In cell B15, type 9500. In cell C15, type 9695. In cell D15, type 8315. In cell E15, type 9275. Display the Name Manager, and then edit the Shirt_Costs name to include row 15. Select Hats_Costs, and edit the name to Headwear_Costs. (Mac users, click Define Name and make edits using the Define Name dialog box.) 4
8 Click cell B19. On the Formulas tab, in the Formula Auditing group, click Error Checking, and then select Update Formula to Include Cells. Use the fill handle to copy the corrected formula from cell B19 across through cell E19. 2
9 On the Quarterly Apparel Costs worksheet, in cell B25, insert a SUM function to sum the Swim_Costs named range, using the name in the formula. Create similar formulas in the range B26:B28, being sure to use the range name in each formula. In B29, calculate a total, and then apply the apply Currency [0] and Total cell style. Apply the Currency [0] style to cell B25 and apply the Comma [0] style to the range B26:B28. Save the workbook. 8
10 On the Quarterly Apparel Costs worksheet, record a Macro using the name Sheet_Title and the Shortcut key CTRL+ j. (Mac users, use Option+Command+ j). Store the Macro in the workbook, and as the Description, type Report heading. Click cell A1, type Front Range Action Sports and then press CTRL+ENTER. Merge and center the text across the range A1:E1, and then apply the Title cell style. In cell A2, type Apparel Costs, and then press CTRL+ENTER. Merge and Center the text across the range A2:E2, and then apply the Heading 1 cell style. Click cell A1, and then stop recording the macro. Delete the text in A1:A2, and then test the macro. Hint: Use the tools on the Developer tab in the Code group. 3
11 Edit the Sheet_Title macro to display the Visual Basic Editor. Select and copy all of the code, close the Visual Basic Editor window, and then paste the code in cell A32. Display the worksheet in Page Break Preview. Move the page break to position it between rows 30 and 31 so that the VBA code displays on Page 2. Return to Normal View and save the file as a macro-free workbook. 4
12 On the Product Information worksheet, select the range A4:C9, and then sort the data by Style Code in ascending order. Select the range A5:C9 and then name the selection Lookup_Table. Hint: Use the tools on the Data tab in the Sort & Filter group. 2
13 On the Phone Order worksheet, in cell A9, type C-SW and then press TAB. In cell B9, use a VLOOKUP function to lookup the Item in cell A9 and insert the description from the Product Information worksheet using the Lookup_Table range as the table array. The description is in column 2 of the table array. Fill the formula down through B18. In cell C9, type 12 and in cell D9, type Blue and then press TAB. Hint: Use the formula =VLOOKUP(A9,Lookup_Table,2) 6
14 In cell E9, use the VLOOKUP function to insert the unit price of the item in cell A9 using the Lookup_Table range as the table array. The unit price is in column 3 of the table array. Fill the formula down through E18. Hint: Use the formula =VLOOKUP(A9,Lookup_Table,3) 6
15 In cell A10, type W-RR and in C10 type 12. In cell D10 type Yellow and then delete rows 11:18. Sum the Order Amount and apply the Total cell style. 3
16 On the Summer Attendance worksheet, in the range G4:G8, insert Line Sparklines to show the attendance trend for each event over the five-year period. Show the High Point and Low Point. Hint: Use the tools on the Insert tab in the Sparklines group. 5
17 Insert a Line with Markers Chart using the ranges A3:F3 and A6:F6. Reposition the chart so that its upper left corner is in A11 and the lower right corner is in F25. Edit the Chart Title to Attendance at Event Live Arizona. Edit the Vertical (Value) Axis to set the Minimum to 6000 and then format the chart using Style 4. 8
18 On the Expense Report worksheet, in the range H15:H21, create formulas to sum the data in each row, not including Date and Description. In cell H22, enter a formula to sum the total expenses. Apply Accounting Number Format to the ranges C15:H15 and C21:H21. Apply Comma Style to the range C16:H20. In cell H22 apply Accounting Number Format and the Total cell style. 5
19 Select the ranges D8:F12 and A15:G21 and format the cells so that when the sheet is protected, the selected ranges are not locked. Protect the sheet and be sure the top check box to protect the worksheet and the first two check boxes in the list are selected. Enter the password go. Hint: Use the tools on the Home tab in the Cells group. 3
20 On the Summer Program Revenue sheet, in cell B4, create a DAVERAGE function to calculate the average of the Amount field for the Lessons category. The Criteria range has been set up for you in the range A3:A4. In cell C4, create a DSUM to calculate the total of the Amount field for the Lessons category. Format the range B4:C4 using Accounting Number Format. Hint: Use the formula =DAVERAGE(A9:E117,”Amount”,A3:A4) in cell B4. Use the formula =DSUM(A9:E117,”Amount”,A3:A4) in cell C4. 5
21 In the Summer Program Revenue sheet, click cell A9, and then insert the Recommended PivotTable Sum of Amount by Location in a new worksheet. Rename the worksheet PivotTable and Chart. Use the Month field as the report filter. Use the Location field as the row labels and the Item field as the column labels. Format the values in the PivotTable using the Number category with zero decimal places and the 1000 separator. Hint: Use the tools on the Insert tab in the Tables group. 9
22 On the PivotTable and Chart worksheet, insert a footer with the file name in the left section and the sheet name in the right section. Change the Orientation to Landscape and center the worksheet Horizontally. Fit the Width to 1 page. 2
23 On the PivotTable and Chart worksheet, insert a PivotChart using the Stacked Column chart type. Move the chart so that its upper left corner is positioned in cell A13, and then drag the lower right sizing handle so that the lower right corner of the chart is positioned in cell H35. Apply the Layout 3 chart layout, and Chart Style 9. Add and center Data Labels to the chart. Replace the text in the Chart Title with Summer Program Revenue and then hide all of the field buttons on the chart. Save the workbook. Note, Mac users, select the range A4:G10 in the PivotTable, and then insert a stacked column chart. Follow the instructions to complete the chart, and ensure that the column headings of the PivotTable display in the legend. The row headings should display on the horizontal axis. 8
24 Display the Maine Store sheet—the first worksheet. Select cell B33, type 3, and then press ENTER. Use Solver to predict breaking even after 3 months. The Set Objective box, should be set to $B$38. Edit the To option to a Value of 0 and the By Changing Variable Cells box should display $B$34, $B$36. Keep the Solver solution. Hint: Use the tools on the Data tab in the Analyze group. 2
25 Save and close the file and submit for grading. 0
Total Points 99

 

Created On: 04/05/2022 1 GO19_XL_COMP_GRADER_CAP2 – Summer Revenue 1.0

Nutrition 300 – Diet Project Part 4

 

Part 4 of your Diet Project is a continuation of the analysis of your diet and health. In Part 4, we will be evaluating our fluid, mineral, and vitamin intake.

Meal, Salad, Cucumbers, Food, Leaves, Tomatoes, Mixed

 

Directions: Fill in the tables and answer the questions based on the data from your Cronometer reports. You will need to refer to both the Trends and Servings reports that you submitted for Diet Project Part 1. Type in a different color text.

Note: The Trends report will show you your average intake for each nutrient, so you DO NOT have to calculate any averages!

Please answer the questions based on the information from your Cronometer reports!

· If a question does not apply to your situation, make sure to say something about it, such as “I’m not an athlete, so this doesn’t apply to me.” That way, I know you looked at the question. Don’t just skip the question!

· I will be grading Part 2 using your Cronometer reports submitted for Part 1. If I see a food on Part 2 that wasn’t recorded on Part 1, or if there is a food I saw from Part 1 that should be on Part 2, you will lose points.

 

Answer the questions based on what you are learning in this course!

· You are required to explain your answers in detail, using your reports and knowledge about nutrition to support your answer.

· Unacceptable responses: “it’s junk/fast/processed food”, “it’s full of nutrients, ”“it’s healthier”, “it’s better”, “I think my diet is healthy”, “I don’t like my diet”, or “my diet is horrible.” These will NOT earn you credit if you don’t explain why.

 

 

Fluids and Beverages – refer to the “Trends” report

1. On the Trends report under “General,” your water intake is reported as grams. You need to convert this into cups of water. Using the following conversions, determine how many cups of water you consumed from foods and beverages. (2 points)

· 1 gram of water = 1 mL of water; 237 mL of water = 1 cup of water

Your Intake of water: _________ g x 1 mL/g = ________mL ÷ 237 mL/cup = ________ cups/day

2. The DRIs for water are below.

· Men: 16 cups; Women: 11 cups

Do you need to increase your water intake? Bold or highlight one. (1 point) Yes No

If Yes, how many more cups of water a day do you need (1 point) =_______ cups ( Hint: subtract your intake from your DRI)

3. What is one consequence of not consuming adequate amounts of fluid? (2 points)

4. Many of the fluids we consume also contribute calories and nutrients to our diet. Using your Servings report, evaluate the quality of your beverages. In general, are they providing additional nutrients or calories beyond water? If so, name a few other nutrients provided by your beverages? (4 points).

 

5. Do you think your beverage choices are helping you achieve overall good health? Why or why not? Consider total fluid amount and associated nutrients. If you feel that your beverage intake is not helping you meet your dietary goals, how can you improve this aspect of your diet? (4 points)

 

Minerals – refer to the “Trends” and “Servings” reports

1. Refer to your Trends report under the “Minerals” section to fill out the table below (2 points)

Mineral My DRI (mg) My Intakes (mg) % of DRI
Sodium 1500    
Potassium Women: 2600 Men: 3400    
Calcium 1000    
Magnesium Women: 320 Men: 420    
Iron Women: 18 Men: 8    

 

2. High sodium intakes have been linked to increased risk for chronic diseases. Refer to your Servings report, identify the 5 foods that provide the most sodium and identify whether they are processed or not. (5 points) Note: processed foods are foods that are man or machine made & do not exist like that in nature. Consider: can you find that food in that form in nature? For example, does bread grow on trees? If not, then it’s processed.

Food Sodium (mg) Processed food? Yes or no?
1.    
2.    
3.    
4.    
5.    

 

3. From the table in question 1, did you exceed your DRI for sodium? Is this what you expected? Why or why not. Do you feel like your diet is high/low in sodium? (2 points)

4. Does your overall diet consist of more than 50% processed foods? (1 point)

5. Did any food surprise you in terms of sodium content? If so, which food and why? (2 points)

 

6. What health condition is most associated with high sodium diets? (1 point)

7. Iron and Calcium are commonly under consumed minerals. Refer to Question 1 – Is your diet at risk for deficiencies for iron and calcium? Answer next to the name of the mineral below (4 points)

a. Anything less than 75% of DRI is considered deficient. If so, what are the major diseases associated with deficiencies of these minerals?

b. If not, and you are over 100% of the DRI, discuss whether you are at risk of toxicity. If you’re over the UL, you are at risk, and you should say what the toxicity symptoms are. (tell me if you’re over the UL, and tell me what risks are associated) – Refer to Table 8.1 (pg. 235) or the table in the “Diet Project” module on Canvas to see the ULs. Iron: Calcium:

 

 

Vitamins – refer to the “Trends” reports

1. Looking at the “Vitamins” section of the Trends report, what is your overall assessment of your vitamin intake? (2 points)

Consider: If your overall intake is low (many vitamins are <75% of the DRI), explain why. Is it because you’re not eating enough calories? Or not eating enough variety? Or eating mostly processed foods? If your overall intake is high, why do you think that is?

 

2. Under the “Vitamins” section, for what 3 vitamins was your “% of DRI” the lowest? Pick your bottom 3 even if they are all high. What are classic deficiency symptoms associated with low intakes of those 3 vitamins? What foods could you add to your diet to increase intake of those vitamins? (4 points)

Lowest 3 vitamins % of DRI Classic deficiency symptom Food source
       
       
       

 

3. Of the 3 lowest vitamins in your diet, which can you realistically increase and how (what food will you add?) (2 points)

Highest 3 vitamins % of DRI Classic toxicity symptoms
     
     
     

4. Under the “Vitamins” section, for what 3 vitamins was your “% of DRI” the highest. Pick your top 3 even if they are low and not over 100%! What are the toxicity symptoms related to excess intake of these vitamins? If there are no associated toxicity symptoms, say “none”. (4 points)

5. When it comes to vitamin toxicity, which class should we be more concerned about – fat soluble or water soluble vitamins? Explain why. (2 points)

 

 

 

1

 

image1.jpeg

BA (Hons) Culinary Arts – Level 6

 

Credit Value 10

Assessments Type LO % Hand in

CW 1 1500 words Feasibility Study

1, 2, 3, 4

100%

Week 10

Summative assessment and marking criteria

Can be found with the assessment instructions and it is important that these criteria are referred to when preparing and writing your assessments.

Formative assessment Students will be expected to work in class on various aspects of the weekly activities and then to translate the tools, techniques and learning into the business that is being planned. Students will review their progress through self and peer assessments, discussions, and meetings with industry professionals. The students will present their business plan presentation to a representative of the Ritz Paris in the following module.

Teaching, learning and assessment overview

This module is delivered in a series of lectures and exercises will give the theoretical framework on which to develop a food and beverage business. It will include examples and case studies on which to develop a feasibility study for your business and then a business plan that is finally pitched to a panel of financiers. Private research will be essential to ensure that you read widely and understand the processes required to assess this venture.

Student hours of study Total 400 hrs

Hours breakdown: Class Contact 40 hrs. Directed and Independent Study 80hrs.

Return of work, feedback and provisional marks will be viewable at the submission point.

Assessment 1 – General feedback will be given in class and then on your written work based on identified criteria in week 1

Term 7

Extenuating circumstances

If serious circumstances beyond a student’s control affect their ability to complete an assessment they may submit a claim for Exceptional Extenuating Circumstances. This must be accompanied by evidence from a competent professional with knowledge of the

circumstances, and all work done to date, by the original assessment submission deadline. Such applications will be considered by an EEC panel. It is important that students familiarise themselves with regulations concerning late submission, for

example, EECs will not be granted for poor time management, minor ailments, computer failure or other such reasons. Please see

http://www.derby.ac.uk/academic-regulations

All marks are provisional until ratified by an Examination Board and the External Examiner.

 

 

3 | P a g e

MODULE DESCRIPTION

This module is specifically designed to help students develop problem identification, problem prioritizing, and problem-solving skills; specifically, the development of skills to understand and apply the cause and effect relationships between performance measures and their causes. It will explore entrepreneurship and business from a strategic level. Students will use their culinary knowledge, skill, and creative thinking to compose an innovative business plan based on their personal culinary focus. Students will be able to understand the relevance and importance of undertaking secondary and primary research within the culinary industry.

The module examines procedures, law, and financial accounting and entrepreneurship considerations. The student will be exposed to business idea generation strategies; analytical procedures, business plan components, financial planning requirements, and improve presentation skills. The module is designed around researching, idea generating and the creation of a feasibility report that will lead to a Business Plan Project.

 

LEARNING OUTCOMES

On successful completion of this unit students will be able to:

 

1. Critically examine the different functional areas impacting the food and beverage service industry and the related decision making;

2. Critically evaluate the feasibility of various components of a food and beverage related to the business plan, and gain an understanding of the various constraints placed upon business decisions due to the external environment;

3. Prepare and present a well-researched business idea and feasibility study relating to a food and beverage business;

4. Persuade, negotiate and convince a third party of the benefits of a tourism or culinary related business concept and opportunity.

KEY SKILLS TO BE DEVELOPED AND MAPPED

The following key skill competencies may be developed and could be used for any portfolio reflections:

 Demonstrate autonomy in planning and managing resources and processes within broad guidelines in significant and extended academic tasks (planning and

management of learning);

 Interact effectively within a learning or professional group, with both a broad and a self critical awareness (interactive and group skills);

 Negotiate in a learning and professional context and manage conflict (interactive

and group skills);

 Be confident and flexible in identification and definitions of problems and application of appropriate knowledge and skills to their solutions (managing tasks

and solving problems).

 

 

 

4 | P a g e

INDICATIVE CONTENT

This module may cover the theoretical and practical aspects of some of the following:

 The Business Plan: An Overview;

 Business Models;

 The chef as an entrepreneur: thinking outside of the kitchen;

 Opportunity, feasibility and Market Analysis;

 The Entrepreneurial Solution and Concept;

 Industry, target customer and Competitive analysis;

 Feasibility Studies;

 The Product Development Process and Operations;

 Product/ Service plan;

 The Offering;

 Developing and Presentation of a Business Plan;

 The Marketing and Sales Plan;

 The Product Development Process and Operations;

 The Management Team and Organizational Structure;

 Critical Risks and Problems;

 Financial Planning;

 Financing sources;

 Writing an Executive summary plus use of Appendices

READING LIST

Students are recommended to utilise the library resources and review a wide range of literature.

Blackwell, E. (2012) How to prepare a business plan, 5th ed, London, Kogan Page.

Calvin, R. (2004) Entrepreneurial management, London, McGraw-Hill.

Dess, G. (2014) Strategic management: Creating a competitive advantage, London,

McGraw-Hill. Drucker, P. (2001) Innovation and entrepreneurship: Practice and principles, Oxford,

Butterworth-Heinemann. Keegan, W.J. and Green, M.C. (2014) Global marketing, 5th ed, London, Pearson Prentice

Hall. Kotler, P. and Keller, K.L. (2014) Marketing management, 14th ed, London, Pearson

Prentice Hall. Lee-Ross, D. and Lashley, C. (2009) Entrepreneurship and small business management in the hospitality industry, Amsterdam, Butterworth-Heinemann.

Lovelock, C. and Wirtz, J. (2011) Services marketing: People, technology, strategy, 7th ed,

Upper Saddle River, NJ, Pearson Education. Morrison, A.J., Rimmington, M. and Williams, C. (1999) Entrepreneurship in the hospitality, tourism and leisure industries, Oxford, Butterworth-Heinemann.

 

 

 

5 | P a g e

Morritt, R.M. (2007) Segmentation strategies for hospitality managers: target marketing for competitive advantage, New York, Haworth Press.

Rollinson, D. (2008) Organisational behaviour and analysis: An integrated approach, 4th ed,

Harlow, UK, Prentice Hall. Ryan, J.D. and Hiduke, G.P. (2008) Small business: an entrepreneur’s business plan

London: South-Western. Sloan D. (2004) Culinary taste: Consumer behaviour in the international restaurant sector,

Amsterdam, Elsevier-Butterworth-Heinemann. (ebook) Slocum, J.W. and Hellriegel, D. (2009) Principles of organizational behaviour, 12th ed,

Mason, OH, South Western Cengage. Stokes, D.R and Wilson, N. (2010) Small business management and entrepreneurship, 5th

ed, London, Thomson Learning.

 

Periodicals, Journals and Magazines:

 Sage;

 Hospitality and Tourism Complete;

 Emerald Library Database;

 The Caterer and Housekeeper. Websites:

These will be recommended by the module leader during the academic year & available on eLearning.

GENERAL INSTRUCTIONS

1. The following details are all key elements of your assigned pieces of work.

2. Plan and organize your work carefully, bearing in mind submission dates.

3. When completing your work, keep checking it carefully against the assessment criteria attached.

4. Your lecturer will advise you of the times during which they will be available for consultation. To manage this resource and time effectively, students are advised to respect these sessions. Please note that this is a student-based research assignment, and as such the tutor may not be able to answer certain questions if it is felt that this would restrict the potential grade.

5. Plagiarism or other forms of cheating will receive a ‘0’ grade and the matter will be reviewed using the University of Derby Academic Offence Regulations.

 

 

 

6 | P a g e

INDICATIVE STUDY PATTERN – TERM 6

Topic area Activities Directed Study

1 Rules of the game

 

To be an ENTREPRENEUR

… or not

 Introduction to the module 1 and 2 – aims and expectations.

 Overview of assessments and the requirements to be met

 Difference between Feasibility Study and Business Plan

 Writing an Executive Summary

 Leadership

 Entrepreneurship

 Risks and rewards

Read the module handbook

carefully.

Understand the success criteria.

 

Find an entrepreneur that inspires

you and be ready to present it.

2 There is only one boss…

the consumer

 WHO understanding

 WHO analysis / WHO research

Further research on your WHO

Draw the ID card of your WHO

3&4 The concept makes it all

(almost).

 

 

Is your idea feasible?

 What is a concept?

 Building a strong concept

 Using research to discover trends

 To understand the source of business ideas

 Know how to develop ideas

 What does feasible mean?

 Understand how the market environment will be crucial for feasibility of your idea and success

 Realize the areas to be researched to ascertain this

 Understand research methods and sources

Further research based on weekly activities. Work on concept

 

 

 

Further research based on weekly activities. Start to develop feasibility of concept.

 

 

7 | P a g e

5 What makes a business successful?

 

 

 

Assess the market

 

 

Legal and technical

feasibility

 

 Business Angels game

 Outline the criteria for evaluating a business

 Analysing and comparing financial statements to evaluate potential businesses

 

 Examine and understand the factors for choosing the ideal location for your future business concept

 Competition analysis

 SWOT

 

 Legal aspects

 Detailed requirements of the facilities,

 Inventory and production control

 Delivery

Major components to be considered when designing a restaurant operation

Further research based on weekly activities. Get the first numbers of your business.

 

 

Find a location

List you key competitors

 

 

Further research based on weekly activities.

Draw your place.

6 Assess the market

 

 

Legal and technical

feasibility

 

 Examine and understand the factors for choosing the ideal location for your future business concept

 Competition analysis

 SWOT

 

 Legal aspects

 Detailed requirements of the facilities,

 Inventory and production control

 Delivery Major components to be considered when designing a restaurant operation

 

 

 

8 | P a g e

7 Finance – It’s all about the

money, money, money

 Financial Statement

 Balance Sheet

 Income Statement

 Statement of Cash Flow

 (Sources and Uses of Cash – Start up costs)

Further research based on weekly activities. Fill in the excel files with your data.

8 Finance – It’s all about the money, money, money

 Financial Statement

 Balance Sheet

 Income Statement

 Statement of Cash Flow

 (Sources and Uses of Cash – Start up costs)

Further research based on weekly activities. Fill in the excel files with your data.

9 Finance – It’s all about the money, money, money

 Cost structures

 Start up costs / monthly costs

 Average check

 Opening days/hours

 Monthly & yearly sales

 

Further research based on weekly activities. Fill in the excel files with your data.

10 Feedback and tutorials

 Face to face meeting & preparation time Students must submit their feasibility

study on FRIDAY week 10 the latest.

 

 

9 | P a g e

ASSESSMENT ONE – 1500 WORD A FEASIBILITY STUDY – 100%

Based on the achievement of learning outcomes 1, 2, 3, 4. To be submitted in week 10

In assessment 1 you are required to prepare a 1500-word feasibility study for a food and beverage operation of your choice. It can be located in any country and for that reason must comply with the country’s laws and regulations, but all financial considerations and any costing must be in Swiss Francs.

Conducting a feasibility study prior to investing the time and money to open a business can help an entrepreneur make a more informed decision about the venture’s chances of success because they often overestimate the size of the market and do not take into account tough competition.

Your research and findings should be included in the feasibility study and referenced appendices can be included. You should cover the following areas although you are free to include more.

1. Executive Summary

2. Consumer understanding

o Consumer description

o Needs / Desires / Likes / Dislikes

o Data, facts, numbers, sources are mandatory

3. Concept & Business objectives;

o Concept

o Value proposition

o USP / Mission statement

4. Assess the market;

o Evaluate potential locations.

o Review competition and the industry that you are entering.

o SWOT

5. Legal requirements

o Local legal requirements

6. Technical analysis

o Detailed requirements of the facilities,

o Inventory and production

o Storage

o Delivery

7. Management analysis

o Skills and talent of the management team

o Primary duties of each person

o Description of the organization structure.

8. Financial analysis

 

 

10 | P a g e

o Balance Sheet (Preopening + 5 years)

o Income Statement (Preopening + 5 years)

o Statement of Cash Flow (Preopening + 5 years)

o (Sources and Uses of Cash – Start-up costs)

o Monthly costs

o Average check

o Opening days/hours

o Monthly / yearly sales

9. Time lines

o Produce timelines and plan.

o Gantt graph

10. Conclusion

o Evaluate profitability and success based on the above factors.

 

Please use the assessment criteria provided overleaf to ensure that you cover the areas where marks will be allocated – all criteria carry the same marks.

 

 

11 | P a g e

ASSESSMENT ONE CRITERIA – 1500 WORD FEASIBILITY STUDY – 100%

Tick the box that meets the criteria achieved – record actual mark on the feedback sheet. You may or may not offer comments to justify your grade.

Criteria 100-70% (1st) 69-60% (2:1) 59-50% (2:2) 49-40% (3rd) 39-35% (referral) Below 35%

Executive Summary

20%

 

Extremely well written executive summary Expressed very well and structured in an appropriate format. All relevant data and information has been accurately and extensively deployed from the feasibility study.

Well written executive summary that is expressed well and structured in an appropriate format. Relevant data and information has been deployed from the feasibility study.

The executive summary is structured in an appropriate format. Most data and information has been deployed from the feasibility study but there are some gaps.

Some thought given to the executive summary that has some structure with a reasonable format. Some gaps in the data and information deployed from the feasibility study.

Poor thought given to the executive summary that has little structure. Many gaps in the data and information deployed from the feasibility study.

Very little thought given to the executive summary. Many gaps in the data and information deployed from the feasibility study. Executive summary and or feasibility study could be missing

Comments

 

 

Research findings and originality.

20%

An outstanding piece of work that is produced to a very high standard. It is exceptionally well researched and the findings are commendable in their originality.

A high quality piece of work that is of a very good standard and is well researched. The findings display originality.

A good standard piece of work with some originality displayed. The work is quite well researched but there are some deficiencies in the findings.

A sound standard of work that is lacking in its research content. Very little originality displayed in the findings.

Overall the work is marginally unsatisfactory and not well researched. No findings or originality has been displayed in the work.

Below the pass standard. Poorly researched and the work lacks any findings and originality.

Comments

Feasibility of work undertaken and results achieved.

20%

An exceptional standard of work illustrating thorough and in-depth understanding of the work undertaken. The concept is entirely feasible.

A high standard of work illustrating a good understanding of the work undertaken. The concept is most feasible.

Overall a good standard piece of work but some lack of understanding of the work undertaken. The concept is fair but not entirely thought through.

Some weakness in the standard of work. There are some significant misunderstandings and errors. The concept debatable and not well thought through.

Some significant errors and misunderstandings in the work. The concept does not demonstrate an understanding of a food and beverage business.

Some serious misunderstandings and errors. A clear fail short of pass standards.

Comments

 

 

12 | P a g e

Grasp of theoretical/ conceptual and practical elements.

20%

Excellent grasp of theoretical/conceptual/ and practical elements related to the feasibility study.

 

Good grasp of theoretical/conceptual and practical elements related to the feasibility study.

Adequate grasp of theoretical/conceptual/ and practical elements related to the feasibility study.

Some grasp of theoretical/conceptual and practical elements related to the feasibility study.

Poor grasp of theoretical/conceptual and practical elements related to a poor feasibility study.

 

Major deficiencies or omissions in theoretical/ conceptual and practical elements. Not a feasibility study.

Comments

Knowledge and understanding demonstrated through workings in the appendices.

20%

Excellent supporting evidence that is appropriate in the appendices. Shows an excellent knowledge and understanding of a new food and beverage concept that is based on appropriate theory. Very logical and well structured with most elements included.

Good supporting evidence that is mostly appropriate in the appendices. Shows a good knowledge and understanding of a new food and beverage concept that is based on theory. Logical and structured with most elements included.

Most supporting evidence provided that is appropriate but with some gaps in the appendices. Shows knowledge and some understanding of a new food and beverage concept but not fully based on theory. Some structure but with elements missing.

Evidence provided but not always appropriate and with gaps in the appendices. Shows little knowledge and understanding of a new food and beverage concept and not based on theory. Very little structure with many elements missing.

Poor supplementary evidence provided, not referenced or structured within the work. Just a collection of material. Elements missing.

Supplementary evidence not provided, referenced or structured within the work. Just a collection of material. No elements

Comments

 

Signed…………………………………………………………………………………………………. Date…………………………………………

 

 

13 | P a g e

FEEDBACK SHEET – 1500 WORD FEASIBILITY STUDY – 100%

 

BA (Hons) Culinary Arts Business Plan for the Entrepreneur 1

Student Name/No

Based on the assessment criteria ticked above convert this to an actual mark using the classification guide.

Criteria

All are equally weighted

1st

100-80

1st

79-70

2.1

69-60

2.2

59-50

3

49-40

Ref

39-35

Fail

34-20

Fail

19-0

Actual mark

Executive Summary

20%

 

20-16 15-14

 

13-12 11-10 9-8 7 6-4 3-0

Research findings and originality.

20%

20-16 15-14

 

13-12 11-10 9-8 7 6-4 3-0

Feasibility of work undertaken and results achieved.

20%

20-16 15-14

 

13-12 11-10 9-8 7 6-4 3-0

Grasp of theoretical/ conceptual and practical elements

20%

20-16 15-14

 

13-12 11-10 9-8 7 6-4 3-0

Knowledge and understanding demonstrated through workings in the appendices.

20%

20-16 15-14

 

13-12 11-10 9-8 7 6-4 3-0

Total 100 marks Actual final mark achieved

 

What you did well?

 

 

 

 

What could you have done better?

 

 

 

 

Improvements to be made

 

  • module overview – please read carefully before you begin your study.
  • module description
  • Learning Outcomes
  • KEY SKILLS TO BE DEVELOPED aND MAPPED
  • Indicative Content
  • Reading List
  • General instructions
  • Indicative study pattern – TERM 6
  • Assessment ONE – 1500 word a Feasibility Study – 100%
  • Assessment ONE Criteria – 1500 word Feasibility Study – 100%
  • Feedback sheet – 1500 word Feasibility Study – 100%

Strategic Marketing for the Food Industry

 

 

This module conforms fully to the relevant UG regulatory framework.

 

 

MODULE OVERVIEW – PLEASE READ CAREFULLY BEFORE YOU BEGIN YOUR STUDY.

 

Module Title Strategic Marketing for the Food Industry

Module Leader

Level 6

Credit Value 10

Term 6

Module Delivery

Mode Face to Face

Student hours of

study Total 100 hrs

Hours breakdown Class Contact 44 hrs. Directed and Independent Study 56 hours

Module Learning

and Teaching

Scheduled Learning and Teaching Activities 25%

Guided Independent Study 75%

Placement Learning 0%

Module Learning

Outcomes

 

On successful completion of the module, students will be able to:

 

1. Identify a range of key strategic marketing terms applied

within the context of the culinary industry and the consequent

impact for marketing products and services;

2. Evaluate the key elements of strategy and the relationship

with the marketing environment and responsible decision

making process;

3. Apply the different concepts and strategies within market

segmentation, targeting and positioning including the

application of the marketing mix.

 

Module Content

 

▪ Marketing for the culinary industry;

▪ The marketing mix;

▪ Service characteristics culinary marketing;

▪ Market segmentation, targeting and positioning;

▪ Designing and managing products;

▪ Promoting products;

▪ Brand awareness;

▪ Digital Marketing;

 

 

3 | P a g e

 

▪ The nature of strategy and strategic management;

▪ relationship between market orientation, analysis of the external

environment and creating value-delivering strategies;

▪ Environmental forces and impacts;

▪ Initial takeover strategies (simulation introduction and trial);

▪ Preparing and managing the strategic plan;

▪ Initial reporting and long term strategic planning.

 

 

Module

Assessment

 

Component 1: COURSEWORK

Summary of Assessment Method: 1500-word Essay – Critically

examine the environment and consider how culinary entrepreneurs

can adopt and adapt their strategies to meet new market challenges

and opportunities within the culinary industry

Weighting: 100 %

Assesses Learning Outcomes: 1, 2 and 3

 

 

 

 

4 | P a g e

 

MODULE DESCRIPTION

This module provides an introduction to Strategic Marketing for the Food Industry and students

will identify a range of marketing terms and begin to understand the impact that these will have

on the marketing of products and services. Marketing requires co-ordination and planning to

ensure market success together with the setting of marketing objectives, goals and targets.

Students will go on to evaluate the key elements of concept and strategy and begin to apply

those in relation to the positioning and application of the component elements of the marketing

mix. Through the effective use of marketing tools, techniques and market research they will

be able to identify the needs and wants of the customer to deliver benefits that will enhance

or add to a responsible customer experience in an ever-changing environment. The food

industry environmental forces faced by marketers offer both opportunities and threats and can

have a significant impact on strategic and tactical decisions made. Students will study the

environment and consider how entrepreneurs can adopt and adapt their strategies to meet

new market challenges and opportunities.

LEARNING OUTCOMES

On successful completion of this unit students will be able to:

1. Identify a range of key strategic marketing terms applied within the context of the

culinary industry and the consequent impact for marketing products and services;

2. Evaluate the key elements of strategy and the relationship with the marketing

environment and responsible decision making process;

3. Apply the different concepts and strategies within market segmentation, targeting and

positioning including the application of the marketing mix.

INDICATIVE CONTENT

This module may cover the theoretical and practical aspects of some of the following:

▪ Marketing for the culinary industry;

▪ The marketing mix;

▪ Service characteristics culinary marketing;

▪ Market segmentation, targeting and positioning;

▪ Designing and managing products;

▪ Promoting products;

▪ Brand awareness;

▪ Digital Marketing;

▪ The nature of strategy and strategic management;

▪ relationship between market orientation, analysis of the external environment and creating

value-delivering strategies;

▪ Environmental forces and impacts;

▪ Initial takeover strategies (simulation introduction and trial);

▪ Preparing and managing the strategic plan;

▪ Initial reporting and long term strategic planning.

 

 

 

5 | P a g e

 

STUDY PATTERN – WEEKLY SCHEDULE

Topic area Activities Directed study

1 Introduction

What is marketing? Definition and key elements

Food and Beverage Industry

▪ Characteritics of service culture ▪ Evolution of F&B marketing

 

Find two F&B businesses that inspire you. Describe their marketing components.

 

 

You should contact your tutor immediately if there is anything that you do not understand or need any clarification on regarding this module

2

PESTEL

▪ Macro environmental elements to be considered

There is only one boss: the consumer

▪ Customer research ▪ Customer understanding ▪ Customer value and satisfaction ▪ Customer loyalty and retention ▪ Customer behaviour / decision making process ▪ Moments of truth approach

 

Carry out the PESTEL of your case study.

 

Analysis of a customer profile. Value

Proposition Canvas

Identify the key customers of the case

study and then for your project.

 

 

 

This is the best time to start writing the

coursework. Start thinking about the

business idea you would like to develop

in the project.

 

3 Market and money

▪ Market segmentation ▪ Targeting ▪ Positioning

 

 

Analysis the market of one business

The Positioning description

 

The class exercises target the detailed

market analysis and the search of the

potential unique selling point for the

project.

 

 

6 | P a g e

 

4 Marketing mix: 7 P’s:

▪ Product ▪ Price ▪ Place ▪ Promotion ▪ People ▪ Process ▪ Physical facilities

Marketing mindset

▪ Commonsense ▪ Guts and passion ▪ Creativity

 

 

Marketing Mix analysis for different

enterprises in the culinary industry

 

Write the marketing mix of your case

study.

5 Competition

▪ Competitive analysis

Marketing strategies

▪ Best in class analysis ▪ Disruptive innovation ▪ Common sense

Preparation and guided studies

 

Competition analysis

Group Work – find your competitive

advantages (individual, group, college)

 

Further analysis of your case study.

 

 

6 Designing a product or service

▪ Definition of product ▪ Factors in designing a product ▪ Brand DNA

 

Best Brand DNA search competition

Further analysis of your case study.

 

 

 

7 | P a g e

 

▪ Life cycle of products and services

 

6 Definition of WHO

▪ The importance of excellent customer understanding ▪ Market research ▪ Data collection

 

Group set up

 

You will be given a target market

You will have to understand your WHO

 

 

Further analysis of your case study.

 

7 Building brand awareness

▪ Digital marketing ▪ Social networks

Create Online strategy

Further analysis of your case study.

8 Influencers

Creater Influencers strategy Further analysis of your case study.

9

 

Guided study / rehearsal Website / FB page / Insta creation

10 Coursework presentation

 

 

 

8 | P a g e

 

 

READING LIST

 

Essential Reading – Students are recommended to utilise the library resources and review a wide range of literature.

Kotler, P., Bowen, J. T., Makens, J., and Baloglu C. (2017). Marketing for Hospitality and

Tourism, Global Edition, 7th ed., Upper Saddle River, NJ: Prentice Hall. (Also available from

the University of Derby)

Osterwalder, A., Pigneur, Y., Bernarda, G., & Smith, A. (2014). Value proposition design: how

to create products and services customers want. John Wiley & Sons. (Also available from the

University of Derby)

Bland, D. J., & Osterwalder, A. (2019). Testing business ideas: A field guide for rapid

experimentation. John Wiley & Sons

Osterwalder, A., Pigneur, Y., Smith, A., & Etiemble, F. (2020). The Invincible Company: How

to Constantly Reinvent Your Organization with Inspiration From the World’s Best Business

Models. John Wiley & Sons.

Evans, N., (2015). Strategic Management for Tourism, Hospitality and Events. New York:

Routledge.

Hudson, S. (2008). Tourism and Hospitality Marketing: a Global Perspective. Sage.

Shoemaker, S., & Shaw, M., (2008) Marketing Essentials in Hospitality and Tourism:

Foundations and Practices, 1/E Upper Saddle River, NJ: Prentice Hall.

Díaz Pérez, F. M. (2010). Competitive Strategies and Policies for Tourism Destinations:

Quality, Innovation, and Promotion. Hauppauge, NY: Nova Science Publishers, Inc.

Enz, C. A., & Harrison, J. S. (2010). Hospitality strategic management. [electronic resource]:

concepts and cases. Hoboken, N.J. : Wiley.

 

GENERAL ASSESSMENT GUIDELINES

Component 1: COURSEWORK Summary of Assessment Method: 1500-word Essay (Individual Essay) Critically examine the environment and consider how culinary entrepreneurs can adopt and adapt their strategies to meet new market challenges and opportunities within the culinary industry. You can consider an existing business or plan the marketing strategy for your future F&B company. Weighting: 100 % Assesses Learning Outcomes: 1, 2 and 3

 

 

9 | P a g e

 

Submission Deadline: Monday Week 10 for the final project (Intermediate deadlines will be

introduced for specific parts of the assessment during the term)

 

The Individual Essay should comprise the following key components:

a. Macroenvironment

b. Customer Description

c. Competition

• Practical implications for the culinary organisation (in the case of the existing business

models or those that could be developed in the future); choose 2 techniques among

the following:

a. Business Model of the business and Value Proposition

b. Marketing Mix (Product/Service, Price, Place, Promotion, People, Process,

Physical Facilities)

c. Marketing Strategy and its adaptation to the changes in the environmental

forces

• Conclusion (summary of the key outcomes)

• Reflection (individual reflection on the project development process; not included to

the word count)

• Reference list (using only reliable sources in Harvard reference style).

If references do not appear in the main text and they are missing either from the main body or

from the list you will receive half the points assuming that the rest is correct. Wikipedia and

other non-academic, non-professional sources will be marked down.

 

Structure of the essay. The Individual Essay should contain title page, introduction, main

text, conclusion, reflection, references, appendix (if necessary).

 

Each Individual Essay should be supported with the small presentation (10 min) during

Week 10 that covers the main outcomes of the project. Each presentation will be followed with

the Q&A session (10 min) and the questionnaire on the projects in the class.

 

ASSESSMENT CRITERIA FOR INDIVIDUAL ESSAY (100%)

 

 

 

10 | P a g e

 

Business idea 20%

Critical analysis of the culinary industry environmental forces

Consumer Description

Competition

Critical thinking and good synthesis of the points researched

Creativity and Originality

30%

Business concept development

Business Model

Marketing Mix

20%

Reflection 20%

References (Harvard style)

Structure (introduction, main text, conclusion, reflection, references)

Clarity of information and expression

Spelling and Grammar

10%

If references do not appear in the main text and they are missing either from the main body or from the list you will receive half the points assuming that the rest is correct. Wikipedia and other non-academic, non-professional sources will be marked down.

 

 

 

 

 

11 | P a g e

 

I ASSESSMENT CRITERIA– INDIVIDUAL REPORT – WEIGHTED 100%

 

Tick the box that meets the criteria achieved – record actual mark on the feedback sheet. You may offer comments to justify your grade.

 

Criteria 100-70% (1st)

69-60% (2:1) 59-50% (2:2)

49-40% (3rd)

39-35% (referral)

Below 35%

 

Research and originality

An outstanding piece of work that is produced to a very high standard. It is exceptionall y well researched and is commendab le in its originality.

A high-quality piece of work that is of a very good standard and is well researched. The work displays originality.

A good standard piece of work with some originality displayed. The work is quite well researched but there are some deficiencies.

A sound standard of work that is lacking in its research content. Very little originality displayed

Overall, the work is marginally unsatisfactor y and not well researched. No originality has been displayed in the work.

Below the pass standard. Poorly researched and the work lacks any originality.

Comments

Use of data that demonstra tes a grasp of theoretical and conceptual elements

All relevant data/inform ation/ skills accurately and extensively deployed. Excellent grasp of theoretical and conceptual elements.

Virtually all relevant data/informatio n/skills accurately and extensively deployed. Very good grasp of theoretical and conceptual elements.

Most of the relevant data/informati on/ skills accurately deployed. Good grasp of theoretical and conceptual elements.

Much of the relevant data/informati on/ skills accurately deployed. Adequate grasp of theoretical and conceptual elements.

Some major omissions or inaccuracies in the deployment of data/ information/ skills. Some grasp of theoretical and conceptual elements.

Major deficiencies or omissions in data/inform ation/ skills/ Major deficiencies or omissions in theoretical and conceptual elements

Comments

Critical analysis and evaluation

A high level of critical analysis and evaluation that displays inclusive original thinking.

A very good level of critical analysis and evaluation that displays original thought.

A fairly good level of critical analysis and evaluation with some evidence of original thinking.

A fair level of critical analysis and evaluation but with little evidence of original thinking

Inadequate critical analysis and evaluation with little evidence of original thought and ideas

Poor critical analysis and evaluation with virtually no evidence of originality or application

Comments

Structure of the argument and coherence of the work

 

High quality piece of work demonstrati ng exceptional clarity of ideas and presentation

A very good standard of presentation that is commendable in its clarity of ideas. Very good sense of coherence and

A good standard of presentation with ideas that is clear and generally coherent. There is some

A sound standard of presentation with ideas that are fairly clear and demonstrate some coherence.

Standard of presentation is not acceptable, and any ideas are unclear and incoherent.

Standard of presentation unacceptabl e and not up to graduate standard with any ideas

 

 

12 | P a g e

 

. The work has excellent coherence and is logical in any arguments.

logic demonstrated in any arguments.

evidence of coherence and logic demonstrated .

There is some evidence of misunderstan ding.

confused and incoherent;

Comments

Communic ated in report format as requested identifying sources used and referenced

Communica ted with exceptional authority and tone. All sources are referenced according to Harvard convention. The higher the mark the less trivial the identificatio n of minor errors in the work.

Communicated with good authority and tone. Sources referenced according to Harvard convention. Very minor errors only.

Communicate d in a sound manner with the right tone. Limited sources identified but referenced according to Harvard convention. Errors identified.

Communicat ed in an acceptable manner with some weakness in style and tone. Very limited sources identified but referenced according to Harvard convention. A number of errors

Poorly communicat ed with weakness in style and tone. Poor range of sources included. References not in accordance with Harvard convention. Many errors identified

Communica tion is incorrect in all aspects. No reading or research undertaken from any sources. Full of errors and just wrong.

Bundling Strategy Ginnie’s Gym Refreshment Bar Hydration Power Drink Satisfying Smoothie

Question 1 Tying as a Bundling Strategy Ginnie’s Gym Refreshment Bar Hydration Power Drink Satisfying Smoothie Early 7.00 5.00 Late 6.00 10.00 
Ginnie has observed that her signature item, the Satisfying Smoothie, is very popular with the late evening crowd at the gym, but it is not so popular with the early crowd. The early and late crowds have only slightly different preferences for her Hydration Power Drink. The gym has a very large clientele, and Ginnie can’t always tell who has the late-crowd preference and who has the early-crowd preference. 
  
In her graduate MBA class, they have been studying tying as a bundling strategy. Ginnie asked her professor, “Would bundling work for my business?” Her professor said, “I think you told me that the marginal costs for you two products differ significantly, so first, I would recommend that you look at the contribution margin for each. Sometimes, low prices may be more profitable and sometimes high prices will be more profitable, especially when there are large differences in the price elasticities of demand.  Second, think about the example of the Happy Meal. People are really there for the hamburger, and the company is leveraging that one item to sell other parts of the menu. What is your lead product, the item customers can’t get elsewhere?” The MC for Hydration Power Drink is $1.00. The MC for the smoothie is $4.00. 

What is the contribution margin at each price for each product? 

  
a) Hydration High Price contribution margin is Blank 1 
  
b) Hydration Low Price contribution margin is Blank 2 
  
c) Smoothie High Price contribution margin is Blank 3 
  
d) Smoothie Low Price contribution margin is Blank 4 Question 2 Continuing the analysis of Ginnie’s Gym Refreshment Bar: Hydration Power Drink Satisfying Smoothie Bundle Price Net Profit Early 7.00 5.00 Late 6.00 10.00 • Calculate the bundle prices and net profits. (10pt) • Determine which bundle price will maximize net profit. Show the steps to support the conclusion. (5pt) • Determine the net profit from a tying strategy.  Show the steps to support the conclusion. (5pts) Question 3 You have developed a self-study certification system for those who need credit hours for recertification by your state’s social welfare office. The system operates at virtually no cost, i.e., there is no marginal cost. A marketing research team has assembled the following sales information. You are researching the options for pricing the courses. Your goal is to achieve maximum revenue to establish funding to maintain and update the system to reflect annual policy changes in licensing requirements. Complete the calculations for Total Revenue by determining how many customers will purchase at each of the segment prices. Online Self Certifications for Social Work License Certification in Online Counseling Certification as a Group Home Counselor Bundle Customers TR Counseling TR Group Home TR Bundle Segment 1 1000 $190 a $70 e $260 4a Segment 2 1000 $150 b $90 f $240 4b Segment 3 1000 $95 c $160 g $255 4c Segment 4 1000 $35 d $195 h $230 4d 
  
a) Blank 1 
b) Blank 2 
c) Blank 3 
d) Blank 4 
e) Blank 5 
f)  Blank 6 
g) Blank 7 
h) Blank 8 Question 4 Continuing with the Table of Certificate Programs, complete the calculations for Total Revenue by determining how many customers will purchase at each of the segment’s bundle price.       Online Self Certifications for Social Work License Certification in Online Counseling Certification as a Group Home Counselor Bundle Customers TR Counseling TR Group Home TR Bundle Segment 1 1000 $190 a $70 e $260 4a Segment 2 1000 $150 b $90 f $240 4b Segment 3 1000 $95 c $160 g $255 4c Segment 4 1000 $35 d $195 h $230 4d 

  
4a) Blank 1 

  
4b) Blank 2 

  
4c) Blank 3 

  
4d) Blank 4 Question 5 Using the Online Self Study Certifications table, answer the following question: At what individual price would the revenue be maximized for the Certification in Online Counseling? Explain/support your answer based on the calculations in question 3. Question 6 Using the Online Self Study Certifications table, answer the following question:
 
At what individual price would the revenue be maximized for the Certification as a Group Home Counselor? Explain/support your conclusion based on the calculations in question 3. Question 7 Using the Online Self Study Certifications table, answer the following question: What is the maximum profit from individual pricing? Question 8 Using the Online Self Study Certifications table, answer the following question: If you employed pure bundling what would be the maximum total revenue? Explain/support your conclusion based on the calculations in question

what asymmetric information, moral hazard, and adverse selection have to do with corporate hiring staff accountants

Context For this discussion, your focus will be on what asymmetric information, moral hazard, and adverse selection have to do with corporate hiring staff accountants. Also see the help provided in the discussion preparation. Instructions Consider the following statement: • Many corporations require all staff accountants to hold not only a degree in accounting but also to have a CPA license. There is a substantial higher cost to hiring CPAs. In your discussion post, address the following: • Speculate on why corporations do not lower their explicit payroll cost by hiring accountants without a CPA. Consider how asymmetric information, moral hazard, and adverse selection may impact the perception of risk. To earn full credit for your discussion, you must complete one post and one follow-up or reply to a classmate. Make sure both the post and the reply focus on the questions asked. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.

Ch 27: The End Of The Cold War Assignment

The Cold War came to an end when the last war of Soviet occupation ended in Afghanistan, the Berlin Wall came down in Germany, and a series of mostly peaceful revolutions swept the Soviet Bloc states of eastern Europe in 1989. Check out this short video and refer to the introduction of Ch 27 From Triumph to Tragedy for more information. Watch this video

Questions: 1. What were the major factors of causes that led to the end of the Cold War?

Name three and explain how they connect to each other (the connection is the part that gets you credit here).

2. What was the end result of the Cold War for the US in 1991? What were the positive outcomes or negative outcomes of being the only remaining superpower from the Cold War era?

3. Given a substantial amount of resources were allocated to fighting the Cold War in a myriad of ways, where did the US military industrial complex focus after the dissolution of the Soviet Union? What region of the world became targeted in the 1990s?

Sufficient =300 words, substantive and addresses the prompt

 

Discussion_1980s_Neoliberalism.pdf

 

1. Give a brief description of Reaganomics and Neoliberalism. 2. How does the neoliberal world view in the 1980s reflect that of the economic

elite during the Gilded Age of the 1880s? Where does social darwinism fall in this discussion?

3. Given the content of the second video, where do you fall in the discussion of regulation vs deregulation. This has been a conversation in US history from the 1860s onward, throughout the Progressive Era to our contemporary period. What is your critique of these ideas, do you think there is common ground or a specific answer to these issues in the US now?

Sufficient = INITIAL POST should contain 300 words, substantive and addresses the prompt. Each of the the required secondary posts and commentary should EACH be at least 150 words of relevant and substantial response. Watch two video:

https://www.youtube.com/watch?v=t41rFqVpB1I https://www.youtube.com/watch?v=EeyGdy_SdhQ

 

Case Analysis Tool Worksheet

 

 

I. Epidemiology/Patient Profile

Andrew is a 17-year-old Caucasian male who has been seen routinely at the clinic since birth presents with his mother with severe right groin and scrotal pain that has persisted for the past four hours. He also complains of nausea but no fever or vomiting. He is currently sexually active.
Sharp and constant right groin pain x4 hours Denies fever or vomiting  
Radiating pain to right scrotum Sexually active x1 year, uses condoms  
Pain started after playing football Denies dysuria, urethral discharge, frequency  
Swollen, tender, erythematous right scrotum Denies abdominal pain  
10/10 pain scale No steroids, dietary supplements, no smoking  
No palpable mass to right scrotum Nausea  
No penile discharge, inguinal lymphadenopathy, or hernias Nothing has relieved the pain  
Negative Prehn sign, absent blue dot sign Had similar pain a few months ago, relieved without any treatment  
Absent cremasteric reflex on the right    
No transillumination of the scrotum    

 

II. Prioritized Cues from History and PE.

Tier 1 Tier 2 Tier 3

 

Andrew is a 17-year-old Caucasian sexually active male with a history of viral gastroenteritis, upper respiratory infection, appendectomy, and behavioral problems. Four hours ago, while playing football, he experienced a sudden onset of severe right groin pain radiating to the right scrotum, for which he now seeks medical attention. He reports that the pain was intermittent at initially but has been consistent and severe over the past couple of hours. On a scale from 0 to 10, he rates the pain as a 10 out of 10. Six to nine months ago, the patient experienced a similar incident that spontaneously resolved. He has accompanying nausea, although he denies vomiting and fever.

 

III. Problem Statement

 

IV. Differential Diagnosis

Leading dx: Testicular torsion (Kaplan, 2018)

History Finding(s) Physical Exam Finding(s)

Severe groin and scrotal pain Swollen, tender, erythematous right scrotum
Acute onset of severe pain Swollen, tender, right testicle without mass
Occurred after playing football 10/10 pain scale
Pain radiating from right groin to right scrotum Negative Prehn sign, absent blue dot sign
Nothing alleviates the pain Absent cremasteric reflex on the right
No past trauma to groin area No transillumination of the scrotum
Prior episode, resolved on its own No palpable mass to right scrotum
Sexually active male No penile discharge, inguinal lymphadenopathy, or hernias

 

 

Alternative dx: Acute Epididymitis (Singh, 2021)

 

History Finding(s) Physical Exam Finding(s)

Severe groin and scrotal pain Swollen, tender, erythematous right scrotum
Pain radiating from right groin to right scrotum Swollen, tender, right testicle without mass
Occurred after playing football 10/10 pain scale
Prior episode, resolved on its own Negative Prehn sign, absent blue dot sign
Nothing alleviates the pain Absent cremasteric reflex on the right
No past trauma to groin area No transillumination of the scrotum
Sexually active male No palpable mass to right scrotum
  No penile discharge, inguinal lymphadenopathy, or hernias

 

Alternative dx: Hydrocele (Brenner & Ojo, 2020)

 

History Finding(s) Physical Exam Finding(s)

Physical discomfort No palpable mass to right scrotum
  Swollen, tender, erythematous right scrotum

 

V. Explanation of Diagnostic Plan and Treatment Plan in prioritized order:

Diagnostic Plan Rationale

Doppler ultrasonography Ultrasonography for blood flow and scrotal imaging (Cash et al., 2020). If the diagnosis is uncertain and the pain is less severe, this test can confirm testicular torsion. If testicular torsion is present, intratesticular blood flow is diminished or absent, resulting in lower echogenicity relative to asymptomatic testis (Kaplan, 2018).
History and physical A history and physical examination suggestive of testicular torsion may necessitate rapid surgical exploration without further diagnostic tests (Kaplan, 2021). In this case, only a medical history and physical examination are necessary to confirm the diagnosis.
Urinalysis Normal in 90% of testicular torsion cases (Cash et al., 2020). If abnormal, it indicates another diagnosis (such as epididymitis or orchitis) (Kaplan, 2018).
Urine Culture

 

To rule out urinary tract infection and epididymitis as the cause of the scrotal symptoms (Schick & Sternard, 2020).

 

 

 

Treatment Plan Rationale

Surgical Intervention Urgent referral to urologist or emergency room. Torsion of the testis is a urologic emergency necessitating surgery (Cash et al., 2020). Testicular necrosis may develop if symptoms linger longer than four to six hours (Domino et al., 2020).
Monitoring Patients should be monitored for postoperative complications, including infection, and delayed complications such as testicular atrophy and infertility (Kaplan, 2018).
Follow-Up Follow- up with urologist as recommended post procedure (Cash et al., 2020)

 

References

Brenner, J. S., & Ojo, A. (2020). Causes of painless scrotal swelling in children and adolescents (A. B. Middleman, G. R. Fleisher, L. S. Baskin, & J. F. Wiley, Eds.). UpToDate. https://www.uptodate.com/contents/causes-of-painless-scrotal-swelling-in-children-and-adolescents

Cash, J. C., Glass, C. A., & Mullen, J. (2020). Family practice guidelines. Springer Publishing Company. https://doi.org/10.1891/9780826153425.0018b

Domino, F. J., Baldor, R. A., Berry, K., Golding, J., & Stephens, M. B. (2021). The 5-minute

clinical consult 2022. Lippincott Williams & Wilkins.

Kaplan, G. (2018). Testicular torsion. Epocrates Web.

https://online.epocrates.com/diseases/50611/Testicular-torsion/Guidelines/Highlights-Basics

 

Ogunyemi, O. I. (2020). Testicular torsion medication. Medscape. https://emedicine.medscape.com/article/2036003-medication

Schick, M. A., & Sternard, B. T. (2020). Testicular Torsion. PubMedhttps://www.ncbi.nlm.nih.gov/books/NBK448199/

Singh, A. (2021). Sexually Transmitted Infections Treatment Guidelines, 2021. MMWR Recomm Rep.

 

70(4);1-187.https://online.epocrates.com/guidelines/586/Epididymitis-in-Adults-

 

Adolescents-2021-CDC-STI-Guidelines-epocrates-Guideline-Synopsis

cultural or ethnic group

This paper will challenge you to apply what you have learned in this course to an investigation of a cultural or ethnic group of your choosing (except white

European Americans). You will, in essence, be thinking like a cross-cultural psychologist. You should position the group’s culture in terms of its location on specific

cultural dimensions (e.g., power distance, uncertainty avoidance) and explain what it tells us about their behavior and psychology.

Address at least five of the following areas in your paper:

 What predictions can be made about the thoughts, feelings, and behaviors of this group in light of their unique cultural background?

 How would a cross-cultural psychologist expect the group to perform on various psychological measures (e.g., a Big Five personality test) and tasks

(e.g., perspective taking, helping strangers)?

 How might social values of this group affect attributions?

 Investigate this culture’s view on psychological disorders, most commonly diagnosed ones, and treatment methods.

 Identify specific communication patterns and their effect on others or the self.

 Address the group’s values regarding autonomy.

 Examine unique life states and their effects on the psyche.

 Investigate sources of perception and stereotypes.

 Analyze this culture’s view of intelligence and methods of measure. Address any conflicts this may have with traditional views and methods.

 Describe how the group’s cultural norms regulate an individual’s display of emotions.

 Explain cultural influences on decision making.

 Provide examples of behavior that might arise based on the type of uncertainty avoidance in this cultural setting.

 Describe how cultural beliefs related to death might affect medical decisions and grieving.

 Discuss the cultural factors that influence one’s likeliness to seek social support in times of stress.

 What cultural factors influence likeliness to conform, and in what situations?

You must integrate concepts from the text, define all terminology, and document your sources. Attend to the rubric prior to formulating your assignment.

 

To get a solution for your task, Kindly click on the order now button or order from our website link; https://gpatargeter.com/order/ , fill in the order form including all your assignment requirement, the number of pages ,deadline, and formatting style for this paper & have your paper written from scratch by an expert