You must show all your work; show the formulas and the accounting rules using Microsoft Excel

Complete the following three questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are meeting the assignment requirements.

Problem 1

	Maintenance	Maintenance
	Hours	Cost (SAR)
January	1,000	45,550
February	1,500	52,000
March	2,100	61,500
April	1,800	57,500
May	800	42,000
June	1,100	47,000

1. Calculate variable cost per unit using the high-low method.
2. Calculate fixed costs.

Problem 2

	Total	Per Unit	Percent of Sales
Sales (40,000 units)	2,400,000	60	100%
Variable expenses	1,600,000	40	? %
Contribution margin	800,000		? %
Fixed expenses	500,000
Net operating income	300,000

1. Calculate variable expense ratio.
2. Calculate contribution margin ratio.
3. Calculate break even sales in units (show your work).
4. Calculate break even sales in Dollars.
5. How many units must be sold to make a profit of SAR 200,000.

Management is considering increasing quality of its units by spending SAR 3 more per unit in variable costs and adding a quality inspector for an additional SAR 60,000 annual fixed cost. Management believes this change will increase unit sales by 10% at the same price.

1. Calculate the new operating profit or loss.
2. Should management make the changes?

Problem 3

GIVEN:	Janitorial Dept.	Cafeteria Dept.	Mixing Dept.	Baking Dept.
Square feet	100	200	1500	3000
Employee count	20	30	80	100
Department cost (SAR)	100,000	150,000	400,000	500,000

Required:

Allocate Janitorial and Cafeteria department costs to mixing and baking departments using the direct method. Use square feet for allocating janitorial costs and number of employees for allocating cafeteria department costs.

You must show all your work.

correct solution only please

Question 4. (7 marks)
The homo economicus view of man’s behaviour as applied to the bulk offinance theory portrays decision makers and being both self-interestedand rational. Neoclassical economics makes some fundamental assumptionsabout people:
1. People have rational preferences across possible outcomes or states of nature.
2. People maximize utility and firms maximize profits.
3. People make independent decisions based on all relevant information.
In light of the following hypothetical experiments, discuss the above

Experiment 1:

Ten people are in Room X (givers) with a further ten people in Room Y(takers). Each giver in Room X will be paired with a taker in Room Yalthough they will not know the identity of the other. Givers have beengiven $20 and can transfer any part of their $20 to a taker in Room Y.Takers can either choose to keep the amount sent, in which case theamount proposed is final or else reject the amount sent, in which caseboth individuals receive nothing. That is, you can send any dollaramount from $0 to $20 and the taker can accept this offer, or reject it,in which case you both receive nothing. For example, If the takeraccepts and you send $10, you keep $20 – $10.
You are a giver. How much do you give?

eBay is known for customers selling to customers. In recent years, there are more products listed that are being sold as new and “through XYZ Company.” Not everyone that shops on eBay is looking for used items. With over 150 million accounts with eBay, it is fertile ground for businesses to reach consumers. Businesses can use e-commerce to gain new customers that may be shopping on e-Bay for used items. E-commerce auction sites can also be used to retain customers may have been lost by offering products on the popular auction sites.

This week for your discussion, you will explore how businesses can use eBay to change the focus from C2C to B2C.

• Is eBay the best online auction for businesses to sell their products? Why or why not?
• How can businesses sell new products that compete with used products when it comes to pricing?
• Should businesses consider selling used and returned products in online auctions? Why or why not?
• In your opinion, what are some of the ways that online auction sites can retain customers? In other words, what are some of the strategies that they can incorporate in order to keep their customers coming back or even gain new customers?

Part 1

Deliverable Length: 600-800 words

Respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.

• Search for and take an online entrepreneurship self-quiz. Identify the website address in your analysis.

• TakeQuiz https://www.forbes.com/2010/08/02/entrepreneur-per… .

Write up to 3 paragraphs analyzing and comparing the results of both quizzes. Answer the following questions:

• What traits do you exhibit?

• Explain why you feel you can be a successful entrepreneur.

• What surprised you about your quiz results?

• Be sure to support your answers with a minimum of 3 quality references.

Part 2

Deliverable Length: 1,500 words

According to Abrams (2012), entrepreneurs make enormous contributions to societies around the globe. Fast-growing entrepreneurial ventures transform entire economies. Even smaller enterprises make tremendous contributions to their health and stability of their communities.

Complete the following:

• Profile an entrepreneur who has created a product or service that you currently use.

• Refer to the infographic titled “Developing Business Prospects,” and discuss the process that this entrepreneur used.

• Compare and contrast their personality attributes with your own.

Reference

Abrams, R. (2012). Entrepreneurship: A real world approach.Palo Alto, CA: Planning Shop

develop a survey-opinion poll to determine if there should be a new product introduced. The questions in your survey-opinion poll should be designed to capture if the current users of the product are unsatisfied or completely satisfied with the product. This information will help you determine as the manager if you will introduce a new product.

(1) research your favorite consumer product (iPhone, Coca Cola, Sony PlayStation, Gucci, Lego, Frito Lay Cheetos, etc.) for changes in trend (trend analysis)

(2) develop a survey-opinion poll to determine if there should be a new product introduced. The questions in your survey-opinion poll should be designed to capture if the current users of the product are unsatisfied or completely satisfied with the product. This information will help you determine as the manager if you will introduce a new product.

(a) The survey must be at least 20 questions.

(b) The survey must have a reference list at the end for each article you researched to gather data on your favorite product.

(c) You must include a statement for your final opinion – introduce a new product or not.

Submission Details:

• Your response should be no less than 250 words
• Follow the APA style of writing with in-text citations and a reference list.