Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
The info in the photo is the only info provided to me.
this the data it is looking for to complete E22A-34 please image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

External Audit Auditing Business Functions And Assets

Authors: Bart Rohman

1st Edition

B0B5NR6TB6, 979-8839201767

More Books

Students also viewed these Accounting questions