Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

October sales were $ 2 9 0 , 0 0 0 . Sales are projected to go up by 1 2 % in November (

October sales were $290,000.
Sales are projected to go up by 12% in November (from the October sales) and another 20% in December (from the November sales) and then return to the October level in January.
25% of sales are made in cash, while the remaining 75% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 5% transaction fee, and deposit the net amount (sales price less the transaction fee) in the store's bank account daily.
Sweeney Corner Shoppe's gross profit is 40% of its sales revenue.
For the next several months, the store wants to maintain an ending merchandise inventory equal to $19,000+25% of the next month's cost of goods sold. The September 30 inventory was $62,500.
Expected monthly operating expenses include:
transaction fee) in the store's bank account daily.
Sweeney Corner Shoppe's gross profit is 40% of its sales revenue.
For the next several months, the store wants to maintain an ending merchandise inventory equal to $19,000+25% of the next month's cost of goods sold. The September 30 inventory was $62,500.
Expected monthly operating expenses include:
Wages of store workers are $8,700 per month
Utilities expense of $1,700 in November and $1,600 in December
Property tax expense of $2,400 per month
Property and liability insurance expense of $400 per month
Depreciation expense of $4,000 per month
Transaction fees, as stated above, are 5% of credit and debit card sales
Fequirements
Prepare the following budgets for November and December:
Sales budget
Cost of goods sold, inventory, and purchases budget
Operating expense budge!
Budgeted income statement
Sweeney Corner Shoppe
Sales Budget
For the Months of November and December
\table[[,November,December],[Cash sales,,],[Credit sales,,],[Total sales,,]]
image text in transcribed

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_2

Step: 3

blur-text-image_3

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

Accounting Principles Volume 1

Authors: Jerry A. Weygandt, Paul D. Kimmel, Donald E. Kieso

11th Edition

1118751752, 978-1118751756

More Books

Students also viewed these Accounting questions