An item will fall under independant demand category when the demand of an item is not
…
Introduction to Computer Application
Excel Assignment 1
In this assignment, you will create a spreadsheet for a business that is providing classes in Microsoft Word, Excel and PowerPoint. The owner wants to look at sales by class and month for the second quarter of the year and calculate monthly profit on the classes as well as by type of class. Open a spreadsheet and do the following:1. Merge cells B1 through D1 and type Software Sales in all caps. Center this in the merged cells. Bold the text as well.2. In cell B2, type Apr. In cell C2, type May. In cell D2, type Jun. Center these in their cells and make them bold.3. In A3, type Word. In A4, type Excel. In A5, type PowerPoint. These should all be bold as well.4. Type in some numbers to represent the sales of each class for each month. Each number should be different. Make sure they all have a dollar sign. You need to do this by formatting the cells as currency with no decimal places.5. In A7, type Sales and make it bold and in italics. In cell E2 type Sales and make it bold and in italics6. Using the SUM function, calculate the total sales for each month. These results should be in cells B7, C7, and D7.7. Using the SUM function, calculate the total sales for each class. These results should be in cells E3, E4, and E5.8. In A8, type Average Sales in bold and italics. Best fit column A so the words PowerPoint and Average Sales display fully.9. Using the average function, find the average sales for each month. These results should be in cells B8, C8, and D8.10. In A9, type Total Profit in bold and italics.11. In E9, determine the total profit. Fill this cell with a different color so that it stands out.12. In cell A12 enter your first and last name. In cell A13 enter your id number
Note:
…
Holding and carrying cost are same ,it is the cost which helps the company in determining the
…
A | B | EMV | |
Alternative 1 | 100 | 150 | 130 |
…
Ordering cost = Number of orders * Order Cost per order
2500 boxes will be sold every quarter of the year, therefore, annual demand = 2500 units * 4 = 10000 units
…
a)57%
Explanation:
Probability that the system
…
Though the manager is managing people, managing products, coordinating events, protecting the environments, still he may face many problems in his day to day activities. Problem solving involves lots
…
On the following a. Provide the list of alternative paths b. The optimal path c. How long does the optimal path take? Task Time Immediate predecessor A 3 N/A B 4 N/A C 5 N/A D 5 A,B,C E 8 D F 7 D G 6 D H 12 E,F,G
…
Need your input on these questions. Please if you don’t have enough ideas DO NOT RESPOND. Thanks.
1- What were the strategic objectives of AT&T and Apple at the beginning of the alliance?
2- What did Apple and AT&T give up to achieve their objectives?
3- Was the alliance equitable to both parties? If not, who got the better deal?
4- How would you calculate or estimate the value that each company got from the alliance?
5- Was Apple really better off choosing an exclusive alliance with AT&T than they would have been if they had offered the iPhone through all carriers simultaneously?
Lastly, look for an alliance case in your own experience, experience of a friend, or from public media, and analyze the following: strategic objectives of both partners, resources and capabilities brought by each partner, and how the alliance adds value.
Search entries or author.
…
The estimated cost of producing 200,000 units is
Direct Material 82
Direct Labor 37
Variable Factory 22
Overhead
Fixed Factory 40
Overhead
The same unit can be purchased for $166 and 40% of
The fixed factory overhead can be saved (avoided) should
The Company make or buy?
If company makes the product:
…