Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I just need the second chart filled out based on the information in the first chart. I also need the excel formulas in each of

image text in transcribedimage text in transcribed I just need the second chart filled out based on the information in the first chart. I also need the excel formulas in each of the spaces as well! Thank you!

Budget information: Projected sales for January, 2021 Average Monthly percantage of sales increase: Average monthly salary expense: Average monthly rent expense: Average monthly utility expense: Average monthly misc. expense: Supplies expense as a percentage of sales: Commission expense as a percentage of sales: Cash sales in month of sale Cost of goods sold-percentage of sales Desired ending inventory-percent of next months COGS Payments of inventory in month of purchase Monthly depreciation for 2020 New equipment cost Salvage value Useful Life (months) Minimum required cash balance Monthly interest rate 128,000 5% 33,400 6,900 5,870 2,650 2% 6% 35% 40% 15% 80% 6,300 160,000 4,000 60 35,000 0.03% CHIPPEWA CHOCOLATES Schedule of Cash Payments for S&A Expenses For the Two Months Ending February 28, 2021 January February Variable costs: Total variable costs Fixed costs: Total fixed costs Cash paid for S&A Expenses

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

Understanding The Use Of Financial Accounting Provisions In Private Acquisition Agreements

Authors: Mark L. Stoneman

1st Edition

1627222731, 978-1627222730

More Books

Students also viewed these Accounting questions