You have been recruited by a former classmate, Susanna Wu, to join the finance team of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Sales commissions Sales staff salaries Telephone and mailing Rental-office building Gas (utilities) Delivery charges Depreciation-office furniture Marketing consultants Amount $ 128,000 45,250 43,700 22,400 12,500 73,100 9,500 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? 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.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 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 Sales commissions Sales staffs salaries Telepone and mailing Rental-sales office building Gas (utilities) Delivery charges Depreciation-office furniture: Existing furniture New furniture Marketing consultants Total budgeted costs < Required 1 % Change % % % % % % % % % % Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 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 Sales commissions Sales staffs salaries Telepone and mailing Rental-sales office building Gas (utilities) Delivery charges Depreciation-office furniture: Existing furniture New furniture Marketing consultants Total budgeted costs < Required 1 % Change % % % % % % % % % % Required 2 Show less 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 Sales commissions Sales staff salaries Telephone and mailing Rental-office building Gas (utilities) Delivery charges Depreciation-office furniture Marketing consultants Amount $ 128,000 45,250 43,700 22,400 12,500 73,100 9,500 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? 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.) Complete this question by entering your answers in the tabs below. Required 1 Required 2 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 Sales commissions Sales staffs salaries Telepone and mailing Rental-sales office building Gas (utilities) Delivery charges Depreciation-office furniture: Existing furniture New furniture Marketing consultants Total budgeted costs < Required 1 % Change % % % % % % % % % % Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 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 Sales commissions Sales staffs salaries Telepone and mailing Rental-sales office building Gas (utilities) Delivery charges Depreciation-office furniture: Existing furniture New furniture Marketing consultants Total budgeted costs < Required 1 % Change % % % % % % % % % % Required 2 Show less
Expert Answer:
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
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...
-
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...
-
Apply normalization (1NF, 2NF and 3NF) of the system description given below and justify why relation needs 1NF, 2NF, and 3NF or not. At the end shift normalized data into Un-Normalized Data. S ystem...
-
How much water must be added to 75.0 mL of 0.332 M FeCl3(aq) to reduce its concentration to 0.250 M?
-
An address field in an instruction contains decimal value 14. Where is the corresponding operand located for a. Immediate addressing? b. Direct addressing? c. Indirect addressing? d. Register...
-
A trapezoidal flat steel plate of thickness \(10 \mathrm{~mm}\) tapers uniformly from a width \(150 \mathrm{~mm}\) to \(100 \mathrm{~mm}\) in a length of \(500 \mathrm{~mm}\). Calculate the extension...
-
Tanner-UNF Corporation acquired as a long-term investment $240 million of 6% bonds, dated July 1, on July 1, 2018. The market interest rate (yield) was 8% for bonds of similar risk and maturity....
-
Use the commutative and/or associative properties to simplify. 5 3 (+) +
-
How can employee empowerment and involvement specifically benefit a company's total quality management focus?
-
Using the Internet, find three examples of promotions for sport products that provide consumers with pricing information.
-
Interview the individuals responsible for licensing and licensing decisions on your campus. Ask them to describe the licensing process and what they believe the advantages are to your school.
-
Define sports products. What are the different types of sports products discussed in the simplified model of the consumersupplier relationship in the sports industry?
-
Develop a list of all the sports products produced by your college or university. Which are goods and which are services? Identify ways in which the marketing of the goods differs from the services.
-
How does the physical environment play a role in sports marketing? How can sports marketers manipulate or change the physical environment?
-
Imagine you are a professor of Social Psychology and are planning to create teams in the class that will work together outside of class on a semester-long project. Based on what you learned, how...
-
Find the market equilibrium point for the following demand and supply functions. Demand: 2p = - q + 56 Supply: 3p - q = 34
-
The landing gear of an airplane can be idealized as the spring-mass-damper system shown in Fig. 3.52 [3.16]. If the runway surface is described \(y(t)=y_{0} \cos \omega t\), determine the values of...
-
A torsional system consists of a disc of mass moment of inertia \(J_{0}=10 \mathrm{~kg}-\mathrm{m}^{2}\), a torsional damper of damping constant \(c_{t}=300 \mathrm{~N}-\mathrm{m}-\mathrm{s} /...
-
A precision grinding machine (Fig. 3.53) is supported on an isolator that has a stiffness of \(1 \mathrm{MN} / \mathrm{m}\) and a viscous damping constant of \(1 \mathrm{kN}-\mathrm{s} /...
Study smarter with the SolutionInn App