Question

Explain in excel. Step by step. Michael Carrigg, Inc., is a disk manufacturer in need of an aggregate plan for July through December. Create an aggregate plan for the given months with the following data:

Month Demand
July 400
August 500
September 600

Answer 1

To create an aggregate plan for a disk manufacturer in Excel, enter the demand for each month in a table, highlight the selection, and insert an appropriate chart type to visually represent the demand.

Step-by-step explanation:

To create an aggregate plan for Michael Carrigg, Inc. for July through September, using Microsoft Excel, you would follow these steps:

1. Open Excel and create a new spreadsheet.
2. In cell A1, type 'Month' to label the first column. In cells A2, A3, and A4, type 'July', 'August', and 'September' respectively.
3. In cell B1, type 'Demand' to label the second column. Then, input the data into cells B2, B3, and B4 with the numbers 400, 500, and 600 as per the given demand for each month.
4. Highlight the cells from A1 to B4 to select both the 'Month' labels and the 'Demand' figures.
5. Go to the 'Insert' tab, and select a chart type, such as a column chart or line chart, to visually represent the demand over the given months.
6. After inserting the chart, Excel will display the demand chart on the spreadsheet. Format the chart as desired, including chart title, axis labels, and any other preferred styling.

This visualization in Excel will provide a clear representation of the demand for the disk manufacturer over the three-month period.