Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

instructions , please look at the requirements and give explanation to the answers that you get please fill it out with proper explanations A 8

instructions ,
please look at the requirements and give explanation to the answers that you get
image text in transcribed
please fill it out with proper explanations
image text in transcribed
A 8 C D E F G The Master Budget Sales and cash collections budgets M Augustine Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has projected sales to be: October November December January $904,000 $964,000 $1,045,000 $936,000 vo 8 Augustine's sales are: 20% cash 10 80% credit 11 12 The company's collection history indicates that credit sales are collected as follows: 13 30% in the month of the sale 14 60% in the month after the sale 15 8% two months after the sale 16 2% are never collected 17 18 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 19 Instruction tab you will be marked wrong. 20 21 Requirements 22 1 Prepare a sales budget for all four months, showing the breakdown between cash and credit sales 23 2. Prepare a cash collections budget for December and January 24 Use cell references from the prior requirement, if applicable NNER a D E F B . 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. (Always use cell references and formulas where appropriate to recelve full credit. If you copy/paste from the instruction tab you will be marked wrong.) on 7 Augustine Reeds Sales Budget For the Four Months Ended January October November December January 8 Cash sales 9 Credit sales 10 Total sales revenue 11 12 2. Prepare a cash collections budget for December and January (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be 13 marked wrong. Use cell references from the prior requirement, if applicable) 14 15 Augustine Reeds 16 Budgeted Cash Collections from Customers 17 For the Months of December and January 18 Month 19 December January 20 Cash sales in current month 21 Collection on credit sales: 22 Credit sales from current month 23 Credit sales made one month ago 24 Credit sales made two month ago 25 Total cash collections 26 27 28 29

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

Benfords Law

Authors: Mark J. Nigrini

1st Edition

1118152859, 9781118152850

More Books

Students also viewed these Accounting questions

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago

Question

How should a consultant be selected?

Answered: 1 week ago

Question

Why is a consulting contract needed?

Answered: 1 week ago