Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started