1. Provide one example of each of the following cost categories in your firm (yo

Posted: September 9th, 2023

1. Provide one example of each of the following cost categories in your firm (you can speculate if there is no information in your 10-K but your example cost should make sense for your company):
Direct material,
indirect material,
direct labor,
indirect labor,
other manufacturing overhead,
period cost (more specific than “SG&A” or “Other”).
Include the link to your company’s most recent 10-K.
2. Using the attached Excel spreadsheet (or a similar one of your own creation), create a line graph of five years of sales, gross margin, COGS, and inventory balances.
Fill in the blank cells with values from your own firm’s 10-K.
Create a graph of your firm’s sales, gross margin, COGS, and inventory balances. To do so, select cells A1 through E6. Click Insert => Recommended Charts => Line.
Change the chart heading to be the name of your firm.
If you need help: https://www.youtube.com/watch?v=YhmVVRwj3p8
In the spreadsheet, respond to the prompt: “What trends, if any, do you see in the data?”
Please use the “Write Submission” option for Part 1 and upload an Excel file for Part 2. Thank you!