PA4. LO 9.3 Assume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here: FAMOUS FOOTBALL FACTORY Cost Center Data-Leather Division Jan. Feb. Mar. Apr. May June $11,801 Leather Scrap Expense $10,000 $10,100 $10,302 $10,405 $11,029 July $13,100 Sep $15,135 Oct. Aug. Nov. Dec. Leather Scrap Expense $14,278 $11,351 $11,351 $11,465 A. Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations. B. Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information: Jan Feb. Apr. Mar. May June Average indoor temperature (F) Air conditioning spare parts inventory Number of air conditioning breakdowns 70 71 70 70 71 73 $3,500 $3,150 $2,898 $2,695 $2,426 $2,207 0 C 2 4 1 Sep July Aug. Oct. Nov. Dec. Average indoor temperature (F) Air conditioning spare parts inventory Number of air conditioning breakdowns 76 74 72 71 70 74 $2,031 $2,010 $2,010 $2,010 $2,010 $1,990 6 1 0 4 Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider. PA4. LO 9.3 Assume you are the leather department manager at the Famous Football Factory. The leather department is a cost center and you are reviewing the scrap costs for the previous year, shown here: FAMOUS FOOTBALL FACTORY Cost Center Data-Leather Division Jan. Feb. Mar. Apr. May June $11,801 Leather Scrap Expense $10,000 $10,100 $10,302 $10,405 $11,029 July $13,100 Sep $15,135 Oct. Aug. Nov. Dec. Leather Scrap Expense $14,278 $11,351 $11,351 $11,465 A. Using Microsoft Excel or another spreadsheet application, create a line chart with markers showing the leather scrap expense. Describe your observations. B. Knowing that leather is susceptible to indoor temperature, you decide to talk with the maintenance manager and obtain the following information: Jan Feb. Apr. Mar. May June Average indoor temperature (F) Air conditioning spare parts inventory Number of air conditioning breakdowns 70 71 70 70 71 73 $3,500 $3,150 $2,898 $2,695 $2,426 $2,207 0 C 2 4 1 Sep July Aug. Oct. Nov. Dec. Average indoor temperature (F) Air conditioning spare parts inventory Number of air conditioning breakdowns 76 74 72 71 70 74 $2,031 $2,010 $2,010 $2,010 $2,010 $1,990 6 1 0 4 Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the indoor temperature, spare parts inventory, and breakdowns. Describe your observations and actions you might consider
