Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please i need answer 5-B and 6 in excel with all steps please and no handwriting 2. Sung Corporation has prepared the following sales budget:

please i need answer 5-B and 6 in excel with all steps please and no handwriting
image text in transcribed
image text in transcribed
image text in transcribed
2. Sung Corporation has prepared the following sales budget: 1-Collections are 40% in the month of sale, 45% in the month following the sale and 10% two months after the sale. The remaining 5% is expected to be uncollectible. 2-The average selling price of the company's products is $100 per unit. 3-The average purchase cost of each unit is $70. Target ending inventories are 25% of the next month's sales. 10% purchases are paid in full in the month of purchase and get a 2% cash discount. The remaining 90% are paid in full in the following month. 4-Total selling, general and administrative costs amount to $4,000 per month, of which $650 is depreciation. 5-(A-Cash in the bank on August 1 is $10,000. ) (B-Inventory on hand on May 1 is 1,500 units.) 6-Prepare the cash budget for Sung Corporation for August. memo: purchases in units

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

Cryptocurrency 101 The Millennials Guide To Understanding And Investing In Crypto

Authors: Candide Ahouandjinou, Jamal Modica

979-8387066771

More Books

Students also viewed these Accounting questions