Case 1: Milligan’s Backyard Storage Kits
Research-Discuss-Plan-Create
Book Case 1
- Description
Congratulations! You have just recieved your first work assignment as a business consultant at your first job.
Your boss has given you the contact information for David Milligan the owner of Milligan’s Backyard Storage Kits. Mr. Milligan believes that with your help he can better understand his current Inventory levels and how he can better manage them. He is interested in knowing this information in order to increase his profitablility as well as to be able to make a presentation to the bank in order to get a loan to expand his business.Because you are new, your boss gives you additional verbal instructions.“Make sure you give Mr. Millian a professional looking spreadsheet.” she says,”Our company is known for professionalism and he has high expectations. Hop on this and get it done quickly. I’ll be back tomorrow to see how you have done.”
- Deliverables
- Discussion with your cohort about the Excel resources
- Discussion with your cohort about the case issues, concepts, and possible solutions
- Discussion with the class about your cohort’s possible solutions to the case and any unresolved issues
- Personal questions you have about the case and Excel
- A professionally designed and accurate Spreadsheet created by your cohort that answeres all of Mr. Milligans questions
- A completed assesment case
- Resources
-
- Case
- Further background on the case: Text pages 1 – 3.
- The design for the solution: Text page 3.
- The information Mr. Milligan needs: Text pages 3 -5
-
- Excel
- How to calculate the average of a set of numbers
- How to calculate the maximum of a set of numbers
- How to calculate the minimum of a set of numbers
- How to calculate the total of a set of numbers
- How to insert the current date and time
- How to insert a chart
- How to sort data even if it is displayed by a chart
- How to format numbers as money
-
- Vocabulary
- Cell: one rectangle on the spreadsheet used to hold data.
- Spreadsheet: a group of cells arranged in columns and rows.
- Range: a group of contiguous cells. (contiguous = next to each other).
- Format or Formatting: the way cells look, their background color, font, borders, Dollar signs, etc.
- Chart: a graphical representation of information. It can be a chart of type bar, pie, line, etc.
- Annual Sales: the total funds accumulated throughout the year by selling products or services.
- Gross: An amount of a specific type, such a profit, prior to removing anything from it.
- Net: An amount of a specific type, such a profit, that represents what is left over from a gross value after everything that needs to be removed from it , such as expenses, have been.
- Cost of Goods Sold: the amount of money spent for production, purchase, shipping, employee salaries, etc. for each unit produced.
- Gross Profit: the difference between Annual Sales and Cost of Goods Sold.
- Inventory: Supplies required for production and final completed Goods.
