Question

In: Accounting

You have been recruited by a former classmate, Susanna Wu, to join the finance team of...

You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has been used for new-product development and to recruit a management team), the control of costs, including marketing costs, is thought by the management team to be essential for the short-term viability of the company.

You have held a number of intensive discussions with Susanna and John Thompson, director of marketing for the firm. They have asked you to prepare an estimated budget for marketing expenses for a month of operations.

You are provided with the following data, which represent average actual monthly costs over the past three months:

Cost Amount
Sales commissions $128,000
Sales staff salaries 45,250
Telephone and mailing 43,700
Rental—office building 22,400
Gas (utilities) 12,500
Delivery charges 73,100
Depreciation—office furniture 9,500
Marketing consultants 26,300

Your discussions with John and Susanna indicate the following assumptions and anticipated changes regarding monthly marketing expenses for the coming year:

  • Sales volume, because of aggressive marketing, should increase by 12%.
  • To meet competitive pressures, sales prices are expected to decrease by 6%.
  • Sales commissions are based on a percentage of sales revenue.
  • Sales staff salaries, because of a new hire, will increase by 12%, regardless of sales volume.
  • Because of recent industrywide factors, rates for telephone and mailing costs, as well as delivery charges, are expected to increase by 9%. However, both of these categories of costs are variable with sales volume.
  • Rent on the office building is based on a 2-year lease, with 19 months remaining on the original lease.
  • Gas utility costs are largely independent of changes in sales volume. However, because of industrywide disruptions in supply, these costs are expected to increase by 17%, regardless of changes in sales volume.
  • Depreciation on the office furniture used by members of the sales staff should increase because of new equipment that will be acquired. The planned cost for this equipment is $28,800, which will be depreciated using the straight-line (SL) method, with no salvage value, over a 4-year useful life.
  • Because of competitive pressure, the company plans to increase the cost of marketing consultants by $4,500 per month.

Required:

1. Based on the preceding information, what is the percentage change, by line item and in total, for items in your budget? (Round percentage answers to 2 decimal places. i.e. 0.1234 should be considered as 12.34%.)

------------------------- ------ ----------- %
MONTHLY MARKETING EXPENSE BUDGET    CHANGE
SALES COMMISSIONS %
SALES STAFF SALARIES %
TELEPHONE AND MAILING %
RENTAL-SALES OFFICE BUILDING %
GAS (UTILITIES) %
DELIVERY CHARGES %
DEPRECIATEION - OFFICE FURNITURE: %
EXISTING FURNITURE %
NEW FURNITURE %
MARKETING CONSULTANTS %
TOTAL BUDGETING COSTS %

2. The management team is worried about the short-term financial position of the new company. Given the strain on available cash, the president has expressed a desire to keep marketing expenses over the next few months to a maximum of $363,000. Discussions with the marketing department indicate that telephone and mailing costs are the only category, in the short run, that can reasonably bear the planned-for reduction in marketing costs. The budget you have prepared includes an assumed 9% increase in telephone and mailing costs. What must this percentage change (positive or negative) be in order to achieve targeted monthly marketing costs? (Hint: The Goal Seek function in Excel can be used to calculate the percentage changes, which can be found under Data, then What-If Analysis.)  (Negative amounts should be indicated by a minus sign. Round percentage answers to 2 decimal places. i.e. 0.123 should be considered as 12.30%)

------------------------- --------- ----------- %
MONTHLY MARKETING EXPENSE BUDGET    CHANGE
SALES COMMISSIONS %
SALES STAFF SALARIES    %
TELEPHONE AND MAILING %
RENTAL-SALES OFFICE BUILDING %
GAS (UTILITIES) %
DELIVERY CHARGES %
DEPRECIATEION - OFFICE FURNITURE: %
EXISTING FURNITURE %
NEW FURNITURE %
MARKETING CONSULTANTS    %
TOTAL BUDGETING COSTS %

***PLEASE SHOW ALL WORK IN A WORKING NOTE. ITS IMPORTANT FOR ME TO UNDERSTAND HOW YOU ANSWERED THIS QUESTION. THANK YOU! *****

Solutions

Expert Solution


Related Solutions

You have been recruited by a former classmate, Susanna Wu, to join the finance team of...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of...
You have been recruited by a former classmate, Susanna Wu, to join the finance team of a company that she founded recently. The company produces a unique product line of hypoallergenic cosmetics and relies for its success on an aggressive marketing program. The company is in a start-up phase and therefore has no significant history of expenses and revenues upon which to rely for budgeting and planning purposes. Given the restriction on available funds (most of the available capital has...
In that regard, you have been asked to join in as a consultant for a company...
In that regard, you have been asked to join in as a consultant for a company with global divisions in Brazil and Russia. Based on cultural differences in those countries, assess two cyber security threats and offer two strategic recommendations on how to defend against the threats.
You have been retained as a finance consultant to advise Panther Production’s management team about potential...
You have been retained as a finance consultant to advise Panther Production’s management team about potential profitability scenarios. The production manager provided you with the following background of the most recent production. Panther Productions Limited has just finished production of the most recent sequel in its Illinois Jones series. The film cost $22 million to produce. Most production personnel and actors were paid a fixed salary (included in the $22 million); however, the two major stars of the film, Chevy...
Researchers recruited 200 70 year-old former factory workers who had been diagnosed with lung cancer, and...
Researchers recruited 200 70 year-old former factory workers who had been diagnosed with lung cancer, and an additional 200 70 yr. old former factory workers who were screened and found to be free of lung cancer. The study participants were asked about their smoking history during the past 50 years. Among those with lung cancer, 127 were smokers. Among those without lung cancer, 35 were smokers. What is the study design? What is the timing? Using the data above, construct...
Spark Inc is a relatively new company and you have been recruited to assist the management...
Spark Inc is a relatively new company and you have been recruited to assist the management with advice and getting to the correct financial figures. 1. Distinguish between a stock split and a stock dividend. Is there any reason for the difference in accounting treatment of these two events? 2. Assume that when you were in high school you saved $1,000 to invest for your college education. You purchased 200 shares of Smiley Incorporated, a small but growing company. Over...
You have been assigned to lead a project team. You have been given a lot of latitude in how you will lead this team.
You have been assigned to lead a project team. You have been given a lot of latitude in how you will lead this team. Think about all of the aspects involved in planning, organizing, staffing, leading and controlling this project team. Write a two-page paper on what the five functions of management mean and how you would utilize each of them to successfully put together and lead this project team. Planning 2. Organizing 3. Staffing 4. Coordinating 5. Controlling
QUESTION 2 You have just been recruited as a corporate sales representative for AN Bank Ghana...
QUESTION 2 You have just been recruited as a corporate sales representative for AN Bank Ghana Limited and you have been charged with the responsibility of handling Universities and Churches accounts. Describe with relevant illustrations the personal selling process that you would undertake to ensure that you are able to close a deal at the end of every month.
You have been recruited by the U.S. Department of Education to identify consumers’ true feelings toward...
You have been recruited by the U.S. Department of Education to identify consumers’ true feelings toward online education. 1.Explain how you would use a word association test to reach your research objective. 2. Explain how Zaltman Metaphor Elicitation Technique would be used to learn the same things. 3.If you were to run a focus group study to answer the same problem, would you select an online or a traditional focus group? Justify your choice.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT