BPC114 - Answer Key

Mesa Community College
Business Administration Department
BPC114 Answer Key - Office 2003


TUTORIAL 1 Tutorials Dalton Documentation Dalton Orders Review Dalton2 Documentation Dalton2 Orders Dalton3 Documentation Dalton3 Orders Cases Problem 1 Altac2Documentation Altac2_Financial Data Problem 2 Halley2_documentation Halley2_Balance Sheet	TUTORIAL 5 Tutorials Vehicle2_AvgMaintCost.pdf Vehicle2_Chart1.pdf Vehicle2_Documentation.pdf Vehicle2_Vehicles.pdf Review VehicleData_Documentation.pdf VehicleData_Q10.pdf VehicleData_Q11.pdf VehicleData_Q12-Q13.pdf VehicleData_Q3-5.pdf VehicleData_Q6.pdf VehicleData_Q7.pdf VehicleData_Q8.pdf VehicleData_Q9.pdf VehicleData_Vehicles.pdf Cases Problem 1 CustomerLoans_Documentation CustomerLoans_Q1-6 CustomerLoans_Q7 CustomerLoans_Q8 CustomerLoans_LoansByTypeAndCity Problem 3 Pledges2_Documentation Pledges 2_Q1-5 Pledges 2_Q7 Pledges 2_Q8 Pledges 2_Q9	TUTORIAL 9 Tutorials Rafting2_Chart 1.pdf Rafting2_CVP Chart.pdf Rafting2_Documentation.pdf Rafting2_Income Statement.pdf Rafting2_Net Income Chart.pdf Rafting2_Scenario Pivot Table.pdf Rafting2_Scenario Summary.pdf Review Season2_Chart2.pdf Season2_CVP Chart.pdf Season2_Documentation.pdf Season2_Income Statement.pdf Season2_Scenario Pivot Table.pdf Season2_Scenario Summary.pdf Season2_Scenario Summary2.pdf Cases Problem 2 Meal2_PivotChart Meal 2_Documentation Meal 2_Sales Meal 2_Scenario PivotTable Meal 2_Scenario Summary Problem 3 Loan2._Mortgage Loan2_Documentation Loan2_Scenario Summary

TUTORIAL 2 Tutorials Budget2 Documentation Budget2 Budget Budget3 Documentation Budget3 Budget Budget3 Loan Analysis Review Family2 Budget Family2 Documentation Family3 Budget Family3 Documentation Family3 Loan Analysis Cases Problem 1 Chem2 Documentation Chem2 Grades Problem 2 Sales2 Documentation Sales2_Sales Summary Works2 Documentation Works 2 Orders	TUTORIAL 6 Tutorials LBC2003.pdf LBC2004.pdf LBC2005.pdf LBC2006.pdf LBCSum2.pdf Review Contrib2006.pdf Cases Problem 1 Java1_Documentation Java1_Annual Sales Java1_Quarter_1 Java1_Quarter_2 Java1_Quarter_3 Java1_Quarter_4 Problem 3 EU_Documentation EU_Quarter_1 EU_January EU_February EU_March NA_Documentation NA_Quarter_1 NA_January NA_February NA_March SA_Documentation SA_Quarter_1 SA_January SA_February SA_March CorporateSummary_Documentation CorporateSummary_Quarter 1 Corporate	TUTORIAL 10 Tutorials Grill2_Answer Report 1.pdf Grill2_Documentation.pdf Grill2_Order.pdf Review Discount2_Discount by Model Report.pdf Discount2_Discount by Model.pdf Discount2_Documentation.pdf Discount2_Standard Discount Report.pdf Discount2_Standard Discount.pdf Cases Problem 2 Rooms2_Documentation Rooms2_Rooms Problem 3 Cuts2_Documentation Cuts2_Cuts

TUTORIAL 3 Tutorials Back Sales2 Documentation Sales2 Sales Review Region2 Documentation Region2 Regional Sales Cases Problem 1 Frosti2 Documentation Frosti2_Golve_Sales Problem 2 Packing2_Packing Slip Packing2 Documentation	TUTORIAL 7 Tutorials DPrpt2_Balance Sheet.pdf DPrpt2_Cash Flows.pdf DPrpt2_Documentation.pdf DPrpt2_Financial Data.pdf DPrpt2_Income Statement.pdf DPrpt4_Balance Sheet.pdf DPrpt4_Cash Flows.pdf DPrpt4_Documentation.pdf DPrpt4_Financial Summary.pdf DPrpt4_Income Statement.pdf DPrpt6_Balance Sheet.pdf DPrpt6_Cash Flows.pdf DPrpt6_Documentation.pdf DPrpt6_Financial Summary.pdf DPrpt6_Income Statement.pdf Frpt2006.pdf Meeting.pdf Review Project.pdf Project2_Documentation.pdf Project2_Projected Income.pdf Project2_Q3-5 Projected Cash Flow.pdf Project4_Documentation.pdf Project4_Projected Cash Flow.pdf Project4_Projected Income.pdf Stkhldrs.pdf Cases Problem 1 Properties2_Documentation Properties2_Overview Properties2_Runners Canyon Properties2_Royal Star Properties2_Bon Air Properties2_Valley Estate Properties2_Pell Mansion Properties2_Oceanfront Properties2_Meadow Lane Properties2_Museum Ready Properties2_Karang Estate Problem 2 Covey2_BarChart Covey2_Documentation Covey2_Expenditures	TUTORIAL 11 Tutorials History.pdf Sunrise.pdf Sunrise1_Current Values.pdf Sunrise1_Documentation.pdf Sunrise1_Fund History.pdf Sunrise1_History Chart.pdf Sunrise1_Portfolio.pdf Sunrise1_Recent Results Chart.pdf Sunrise1_Recent Results.pdf Sunrise1_Sunrise Fund.pdf Review Index1_Documentation.pdf Index1_Dow Jones.pdf Index1_Index Chart.pdf Index1_Index Table.pdf Index1_NYSE.pdf Index1_Summary.pdf Index1_Yield and PE Values.pdf NYA2005.pdf Cases Problem 1 Homesales_ListingsTable Homesales_Documentation Homesales_HomeListings Problem 2 Orders_Documentation Orders _Customers Orders_Products Orders_Product_Order

TUTORIAL 4 Tutorials Space.pdf Vega2_Column Chart of Sales.pdf Vega2_Documentation.pdf Vega2_Pie Chart of Sales.pdf Vega2_Sales.pdf Review VegaUSA2_Documentation.pdf VegaUSA2_MonthlySalesChart.pdf VegaUSA2_Monthly Sales.pdf VegaUSA2_Pie Chart of Total Sales.pdf Cases Problem 1 Park2_Documentation Park2_Park Usage Park2_Usage_Chart Park2_ Usage_Chart2 Problem 3 Oil2_Documentation Oil2_Stock Values Oil2_Stock Chart	TUTORIAL 8 Tutorials Stock2_Documentation.pdf Stock2_History Log.pdf Stock2_REporter.pdf Review Chart2_Documentation.pdf Chart2_Reporter.pdf Cases Problem 2 MediTrax2_Documentation MediTrax2_Week_1 MediTrax2_Week_2 MediTrax2_Week_3 HWSales2_Sales Table.pdf Problem 4 Playhouse_Invoice Playhouse_Documentation	TUTORIAL 12 Tutorials Datalia2.pdf Panel.pdf Review Bad.pdf Good.pdf Powder2.pdf Cases Problem 1 Pixal2_Sales Pixal2_Documentation Problem 3 Stats2_Documentation Stats2_Stats

Email corrections to Christine Held : cheld@mail.mc.maricopa.edu

Business Administration Department
1833 W. Southern Ave. (480) 461-7725
Mesa, AZ 85202-4866

Revised: 9/14/2005 - www.mc.maricopa.edu/dept/d07/bpc114/2003_answers.html