Reference no: EM132572436
You have been asked to analyze the cost structure for the Marketing Department. Your results will be used along with sales projections to determine whether the Marketing Departments needs to increase or reduce staff next year. You have been provided with data for the last six months:
Salaries and Units Commissions
January 10,000 $1 ,700,000
February 12,000 $1 380,000
March 15,000 $2,090,000
April 18,000 $2,375,160
May 16,000 $2,180,000
June 13,000 $1,940,000
Required: (Enter Answers in Excel file)
Question 1: Using the high-low method. develop the cost formula for the Marketing Department. (Round off the variable cost per unit posted to the nearest cent and the total ?xed cost to the nearest dollar)
Question 2: What would be the expected cost if the Marketing Department sold 14,000 units in one month?
|
Surveillance vs. public health surveillance
: What distinguishes public health surveillance from other types of surveillance, such as criminal surveillance, military surveillance, and so forth?
|
|
Explain how cloud service models fit in
: Explain how Cloud Service Models (IaaS, SaaS, PaaS) and How Microsoft Office 365, Azure Fit In? Explain the AWS? Read SP 1800-4 DRAFT Mobile Device Security.
|
|
Determine the profitability index and payback period
: Determine the Profitability index and Payback period.A project requires an initial investment of Br. 180,000. It generates the net cash flows for six years
|
|
Explain what happens when a session is hijacked
: Explain what happens when a session is hijacked. Describe the difference between spoofing and hijacking. Describe different types of session hijacking.
|
|
Develop the cost formula for the marketing department
: Using the high-low method. develop the cost formula for the Marketing Department. (Round off the variable cost per unit posted to the nearest cent)
|
|
What is the importance of diversity in the workforce
: How would you build and maintain a climate of mutual respect and trust among employees? What is the importance of diversity in the workforce?
|
|
How cryptography can be used for data security
: How cryptography can be used for data security or infiltration, focusing on strengths and weaknesses, modes, as well as issues that must be addressed.
|
|
Prepare the stockholders equity section for reynolds company
: Prepare the stockholders' equity section for Reynolds Company at December 31, 2016. Jan. 1 30,000 shares of preferred stock issued at $45 per share.
|
|
About the computer equipment
: Post one important consideration in choosing a form of business organization for this firm that will best allow it to meet John's objectives.
|