Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me figure this out ASAP - i will give a good rating!!! 2nd picture is the data info :) CAMDEN COMPANY October November

image text in transcribedimage text in transcribed

please help me figure this out ASAP - i will give a good rating!!! 2nd picture is the data info :)

CAMDEN COMPANY October November December Pro Forma a. Sales Budget Cash sales Sales on account Total budgeted sales October November December Pro Forma b. Schedule of Cash Receipts Current cash sales Plus collections from AR Total collections c. Inventory Purchases Budget Pro Forma Data October November December Budgeted cost of goods sold Plus: Desired ending inventory Inventory needed Less: Beginning inventory Required purchases (on account) d. Schedule of Cash Payments Budget for Inventory Purchases Pro Forma Data October November December Payment of current month's accounts payable Payment for prior month's accounts payable Total budgeted payments for inventory e. Selling and Administrative Expense Budget Pro Forma Data October November December Salary expense Sales commissions Supplies expense Utilities Depreciation on store fixtures Rent Miscellaneous Total S&A expenses $ 125,000 40% 60% 8% 100% 60% Part a. October sales Sales in cash Sales on credit Expected sales growth per month Part b. Accounts receivable collected in month following sales Part c. Cost of goods sold as percentage of sales Ending inventory - percent of next month's cost of goods sold December estimated ending inventory Part d. Accounts payable paid in month of purchase Accounts payable paid in month following purchase Part e. Salary expense (fixed) Sales commissions (percent of sales) Supplies expense (percent of sales) Utilities (fixed) Depreciation on store fixtures (fixed) Rent (fixed) Miscellaneous (fixed) 10% 6,000 $ 70% 30% $ $ 9,000 5% 2% 700 2,000 2,400 600 82,000 10,000 3 Cost of store fixtures Salvage value - store fixtures Useful life (years) - store fixtures Part g. Borrowing increments Monthly interest rate Cash cushion $ 1,000 1% 6,000 $

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

More Books

Students also viewed these Accounting questions