Ontario, Inc. manufactures two products, Standard and Enhanced, and applies overhead on the basis of direct-labor hours. Anticipated overhead and direct-labor time for the upcoming accounting period is $800,000 and 25,000 hours, respectively. Information about the company’s products follows.

	Standard:	Enhanced:
Estimated production volume	3,000 units	4,000 units
Direct-material cost	$25 per unit	$40 per unit
Direct labor per unit	3 hours at $12 per hour	4 hours at $12 per hour

Ontario’s overhead of $800,000 can be identified with three major activities: order processing ($150,000), machine processing ($560,000), and product inspection ($90,000). These activities are driven by number of orders processed, machine hours worked, and inspection hours, respectively.

Data relevant to these activities follow:

	Orders Processed	Machine Hours Worked	Inspection Hours
Standard	300	18,000	2,000
Enhanced	200	22,000	8,000
Total	500	40,000	10,000

Top management is very concerned about declining profitability despite a healthy increase in sales volume. The decrease in income is especially puzzling because the company recently undertook a massive plant renovation during which new, highly automated machinery was installed—machinery that was expected to produce significant operating efficiencies.

Using a Microsoft Excel format for calculations, complete the following:

• Assuming use of direct-labor hours to apply overhead to production, calculate the unit manufacturing costs of the standard and enhanced products if the expected manufacturing volume is attained.
• Assuming the use of activity-based costing, calculate the unit manufacturing cost of the standard and enhanced products if the expected manufacturing volume is attained.
• Ontario’s selling price is based heavily on cost:
  • Calculate which product is over cost and which is under cost by using direct-labor hours as an application base.
  • Explain if it is possible that this over costing and under costing is responsible for the profit issues the company is facing.
• Illustrate how the solution will change if the following data changes:
  • The overhead associated with order processing is $300,000 and the overhead associated with product inspection is $270,000.

Present your work in Microsoft Excel spreadsheet format. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M5_A2.xls.

Complete the problems below and submit your work in an Excel document.  Be sure to show all of your work and clearly label all calculations. All statistical calculations will use the Employee Salary Data Set (in Appendix section).

(Note: Questions 1- 4 have additional elements to respond to below the analysis results.)

1. Last week, we found that the average performance ratings do not differ between males and females in the population.  Now we need to see if they differ among the grades.  Is the average performance rating the same for all grades?  (Assume variances are equal across the grades for this ANOVA.)
2. While it appears that average salaries per grade differ, we need to test this assumption.  Is the average salary the same for each of the grade levels?  (Assume equal variances, and use the Analysis toolpak function ANOVA.)  Use the input table to the right to list salaries under each grade level.
3. The table and analysis below demonstrate a 2-way ANOVA with replication.  Please interpret the results.
4. Many companies consider the midpoint to be the “market rate” – what is needed to hire a new employee.  Does the company, on average, pay its existing employees at or above the market rate?
5. Using the results through this week, what are your conclusions about gender equal pay for equal work at this point?

There are three different word document and one excel document. You have been asked to create a budget proposal. When you onpen the project activity for all the week 1 to 7, you would know how to work on it. All these document will help you to do the project. Make sure to label it. For example week 1, week 2. Labeling is most important so I know which one is which. You have to choose one business to work on that is in week – 1 of project activity for all the week.  Week – 1 is needed by 11th may saturday and other weeks needed by 18th may saturday

a) Access is a spreadsheet application. b) Publisher is an application used for desktop publishing. c) The title bar displays the file name and type of document. d) A window is hidden when Maximize LiL is clicked. e) Press the Home key to move the insertion point to the end of a line of text. f) Press the Alt key to cancel the current operation. g) Press the Esc key to exit Backstage view. h) An arrow on a button indicates that additional commands are available. i) The Format tab is displayed on the Ribbon when Word is started. j) The default button in a dialog box is selected by pressing the Enter key. k) Answer to History? is an example of a valid, descriptive file name. 1) Any changes made to a document after sav ing are automatically stored in the file on disk. m) The file extension .docx indicates the file was created in Excel 2010. n) It is possible to print only the second page of a document. o) A Boolean expression evaluates to either true or false. p) MLA is an accepted form for citations. q) A word processor application and a spread sheet application can be running at the same time. r) Only one Word document can be opened at a time. s) Outlook is an e-mail client. t) E-mail messages are private. u) Phishing is a type of online fraud. v) A virus is a type of computer game.

Given  and , find:

 

a.	[removed]

 

 

b.	[removed]

 

 

 

c.	[removed]