producing a new type of umbrella

Everything Umbrella Inc. is considering producing a new type of umbrella. This new pocket-sized umbrella would fit into a coat pocket or purse.

Prepare a table with three columns to include the following information:

  • Classify the costs of this new product as direct materials, direct labor, manufacturing overhead, selling, or administrative.
  • Classify the costs listed as either product costs or period costs.

List of expenses incurred by Everything Umbrella Inc.

  1. Cost of advertising the product.
  2. Fabric used to make the umbrellas.
  3. Maintenance of cutting machines used to cut the umbrella fabric so it will fit the umbrella frame.
  4. Wages of workers who assemble the product.
  5. President’s salary.
  6. The salary of the supervisor of the people who assemble the product.
  7. Wages of the product tester who stands in a shower to make sure the umbrellas do not leak.
  8. Cost of market research survey.
  9. Salary of the company’s sales managers.
  10. Depreciation of administrative office building.

SLP Assignment Expectations

The table should be easy to read and nicely formatted with adequate explanations. Here is an example of the first two lines of a table.

Expense itemDM/DL/OH/Sell./Adm.Product/Period
AdvertisingSelling expensePeriod cost

The use of Excel is required. Here are a couple of resources for using Excel if you have limited experience with this tool.

Excel Made Easy – A Beginner’s Guide. Keynotes. Retrieved from

Excel 2016. [Videos]. GCF Global. Retrieved from

Both content and presentation will be evaluated.

Leave a Reply

Your email address will not be published. Required fields are marked *