Question: please complete question E22A-34 in excel thank you The info in the photo is the only info provided to me. this the data it is

please complete question E22A-34 in excel thank you
please complete question E22A-34 in excel thank you The info in the
The info in the photo is the only info provided to me.
this the data it is looking for to complete E22A-34 please photo is the only info provided to me. this the data it

E22A-34 Preparing an operating budget-selling and administrative expense budget Consider the sales budget presented in Exercise E22A-33. Stewart's selling and administrative expenses include the following: Learning Objective 6 Appendix 22A Otr. ended Mar. 31 total S&A exp. $21,700 I Rent, $1,100 per month Salaries, $2,000 per month Commissions, 4% of sales Depreciation, $1,800 per month Miscellaneous expenses, 3% of sales Prepare a selling and administrative expense budget for each of the three quarters of 2016 and totals for the nine-month period. Stewart, Inc. sells tire rims. Its sales budget for the nine months ended September 30, 2016, follows: Quarter Ended Nine-Month Total March 31 June 30 September 30 Cash sales, 20% Credit sales, 80% Total sales $ 20,000 80,000 $ 100,000 $ 30,000 120,000 $ 150,000 $ 25,000 100,000 $ 125,000 $ 75,000 300,000 $ 375,000 In the past, cost of goods sold has been 40% of total sales. The director of marketing and the financial vice president agree that each quarter's ending inventory should not be below $10,000 plus 10% of cost of goods sold for the following quarter. The marketing director expects sales of $200,000 during the fourth quarter. The January 1 inventory was $36,000. Prepare an inventory, purchases, and cost of goods sold budget for each of the first three quarters of the year. Compute cost of goods sold for the entire nine-month period. E22A-34 Preparing an operating budget-selling and administrative expense budget Consider the sales budget presented in Exercise E22A-33. Stewart's selling and administrative expenses include the following

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!