Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help asap. Thank you so much, having trouble with question 2 Palm-West Products (A) 1. Background Valerie Preston formed Palm-West Products, Inc. in 2003
Please help asap. Thank you so much, having trouble with question 2
Palm-West Products (A) 1. Background Valerie Preston formed Palm-West Products, Inc. in 2003 when she obtained an exclusive franchise to nationally distribute designer windows. Recent high sales growth of the base window (WIND-B), along with expected sales growth for a new enhanced window (WIND-E), requires adding management team members. Ms. Preston is keenly aware of other growth-oriented companies within the designer window sector that have run out of cash and gone into bankruptcy. Seeing potentially viable businesses fail particularly concerns Ms. Preston and, consequently, she wants to ensure that sufficient cash will be available to accommodate PWP's expected growth. She would like to present a financial plan to PWP's board of directors and needs a financial model that can be used to address questions from top management and members of the board of directors. She would also like to provide the board with a graphical cost-volume-profit analysis. 1.1 Company information From her prior education and work experience, Ms. Preston understands that the starting point for a financial plan is a reliable sales forecast. Thus, she conferred with Tom Sellers, the sales manager, along with an outside marketing consultant. Tom has studied industry sales and economic trends, along with other important market factors within the highly competitive designer window industry to establish a unit sales forecast. As shown in Exhibit 1, total monthly unit sales volume is expected to continue increasing over the third quarter, but with sales mix shifting toward the new enhanced window(WIND-E). Since Palm-West Products does not want to forfeit market share to competitors, it maintains a policy to never stock out of its windows. Prior to June, PWP sold only the basic window (WIND-B) at a price of $230 per unit. PWP purchases the WIND-B model from an overseas manufacturer for $155 per unit. In June, PWP began carrying a premium model WIND-P, priced at $380, which costs $225 from the manufacturer. The current sales mix is 80% WIND-B and 20% WIND-P. However, the company expects this mix to shift toward the premium model, along with ongoing competitive pricing pressure (see Exhibit 1). Palm-West Products (A) The company's monthly operating expenses (organized by cost behavior) are provided in Exhibit 2. For simplicity, the company assumes that all operating expenses are paid in cash during the month incurred, with the exception of depreciation and insurance expense. To simplify, assume no tax consequences. Unit Sales Total BASE PREMIUM Forecasted Sales Volume July August September 10,200 11,400 12,700 7,956 8,550 9,017 2,244 2,850 3,683 225 221 216 Sales Price BASE PREMIUM 372 365 358 155 Unit Cost BASE PREMIUM 155 225 155 225 225 Exhibit 1. PWP's sales forecast and other sales information. Variable: Sales commissions (% of sales dollars) Shipping & handling (per unit sold) 5% of sales $15 per unit Fixed: (per month) Wages and salaries 315,000 Rent 26,000 Utilities 9,500 Insurance expired 4,500 Depreciation 16,000 Other S&A 38,000 Exhibit 2. PWP's planned operating expenses per month. 1.2 Requirements Palm-West Products (A) 1. Prepare an Income Statement for July. 2. Tom Sellers suggests that an advertising campaign at a cost of $50,000 per month, combined with increases in sales commissions from 5 percent to 8 percent will improve WIND-B and WIND-P sales and profitability. Calculate Net Income in July if the advertising campaign, and increase in sales commission increase sales in July of both products by 10 percentStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started