I am having a hard time with this. Can I get some help with this please.

Suppose you are an operations manager at a large production facility that produces paper products. You are reviewing data findings showing that the cost of producing your brand of paper towels has risen almost twenty percent over the past six months. These costs include raw materials, equipment, labor costs, and building and administration costs. The labor contract with workers was just renewed. The pressing machines had to be upgraded. Raw materials costs are fluctuating. The following costs for making the paper towels were identified:

Today's Production Costs: The costs from six months ago are included in an

Date	Softwood Costs	Chemical Glue and Resin Costs	Equipment Costs	Labor Costs	Building and Administration Costs	Total Production Costs	Selling Price	Profit Margin
6 Months Ago Production Costs	8 cents	2 cents	5 cents	10 cents	25 cents		1 dollar
Today's Production Costs							1 dollar

In row three (Today's Production Costs), fill out the following Excel columns with the following information.

• Softwood Costs - ten cents per paper towel roll.
• Chemical Glue and Resin Costs - two cents per paper towel roll.
• Equipment Costs - pressing machines - five cents per paper towel roll.
• Labor Costs - twenty cents per paper towel roll.
• Building and Administration Costs - twenty-five cents per paper towel roll.
• Total Paper Towel Production Costs - sixty-two cents per paper towel roll. We sell the paper towels at $1.00 per roll.

You have been asked by your Chief Operating Office via email to address the following questions in an email response:

1. What is the profit margin per paper towel roll?
2. What are the production costs per paper towel produced?
3. What is the significance the cost increases from the past 6 months?
4. Why is it necessary to set up a trend analysis for this situation?
5. What are some recommendations to counteract the new setup costs?