excel and microsoft

0 comments

  1. Select a company name for your cookie company.
  2. Determine job specifications: cookie quality, size, appearance, special features (types of chips, nuts) quantity, and packaging. (See the quality standards information below).
  3. Determine production tasks and feel free to enlist your family, friends or classmates in this project.If you enlist help, you may want to make team assignments (i.e., mixer, baker, timer, quality control, materials purchaser, accountant, marketer).
  4. Select a recipe.
  5. Using Excel, develop job measurement document. (See information below)
  6. Using Excel, develop job order cost card. (See information below)
  7. Produce your product and complete the job measurement and job cost information.
  8. Take a picture of your final product and create a promotional piece for your product. (Create in Microsoft Office Word (.doc or .docx) or Rich Text format (rtf.)
  9. Evaluate results of your process, and final product.Determined your quality standards. (See information below). (Create your final evaluation results in a Microsoft Office Word (.doc or .docx) or Rich Text format (rtf.) for submission.)

Job Measurement Document

  • Cost per cookie
  • Number of cookies produced=number meeting specs + number rejected + number reworked + number sampled for quality control + unexplained differences
  • Size of cookies before baking
  • Size of cookies after baking
  • Total throughput time=mix time + (bake time for one cookie sheet x number of cookie sheets processed) + packaging time + downtime + cleanup time

Required Comments:

  • What is your cost per cookie?
  • What measures did you use to effectively evaluate production performance?
  • What measures did you find unnecessary? Why?

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}