Question: Required: Construct a profit plan for the first 6 months of 2018 using the templates provided for Shady Lady, Inc (a fictional company). Assume it

 Required: Construct a profit plan for the first 6 months of
2018 using the templates provided for Shady Lady, Inc (a fictional company).
Assume it is the beginning of the year. This project must include

Required: Construct a profit plan for the first 6 months of 2018 using the templates provided for Shady Lady, Inc (a fictional company). Assume it is the beginning of the year. This project must include all of the following schedules: 1. Cash Purchases Disbursements Budget 2. Operating Expense Budget 3. Summary Cash Budget 4. Budgeted Income Statement INFORMATION FOR SHADY LADY BUDGET PROJECT 1. Shady Lady, Inc. is a company that re-sells one product, an extraordinarily large and colorful sun shade umbrella. An overseas contractor makes the product exclusively for Shady Lady; so, Shady Lady has no manufacturing-related costs. 2. As of 11/17, each sun shade umbrella costs Shady Lady $4 per unit. Shady Lady currently sells each umbrella for S10 per unit. 3. The estimated sales (in units) are as follows: Nov 2017 11,250 Dec 2017 11,600 Jan 2018 10,000 Feb 2018 11,400 Mar 2018 13.000 Apr 2018 15,600 May 2018 18,000 June 2018 22,000 July 2018 19,000 4. Per an existing contract, the cost of each umbrella is scheduled to increase by 10% on March 1, 2018, To offset this increase, the company plans to raise the sales price to $1.00 per unit beginning May 1,2018. The sales forecast (i.e., estimated sales in units) takes this price increase inte account

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!