Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Our Business needs your Help to Prepare the Cash Budget for the Upcoming Month of June, using the Following Data; 1. The Business Plans to

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Our Business needs your Help to Prepare the Cash Budget for the Upcoming Month of June, using the Following Data; 1. The Business Plans to PRODUCE 4,000 Bikes \& SELL 3,000 Bikes in the month. 1. The Sales price per Unit is $200 each. 2. 60% of All Sales are on Credit and 40% are for Cash. 3. 40% of the Credit Sales are collected during the current month and 60% are collected later. 2. Variable Costs Include; 1. Direct material =$40 per unit, Direct Labor =$60 per unit, 2. Indirect Materials =$30 per unit 3. Customer Shipping \& Sales Commissions Costs =$20 per unit 4. 75% of All Variable Costs are paid for During the month and 25% are paid in the month Following. 3. Fixed Costs Include; 1. Manufacturing Salaries =$60,000 per month 2. Factory Rent Costs =$40,000 per month 3. Machinery Depreciation =$10,000 per month 4. SGA Costs =$30,000 per month 3. Fixed Costs Include; 1. Manufacturing Salaries =$60,000 per month 2. Factory Rent Costs =$40,000 per month 3. Machinery Depreciation =$10,000 per month 4. SGA Costs =$30,000 per month 5. All Fixed Costs are paid for During the month incurred 4. Other Info; 1. The Business is Planning to Purchase New Equipment in the Month for $55,000 Cash. 5. The Beg Cash Balance estimated for June 1st=$90,000 and the minimum cash amount required at all times is $60,000. Compute the Budgeted Cash Receipts for the months Activity. Compute the Budgeted Available Cash Compute the Budgeted Total Cash Disbursements Compute the Budgeted Ending Cash Excess or (Deficiency) Before Any Compute the Budgeted Ending Cash Excess or (Deficiency) Before Any Financing for the Month. Compute the Amount of Borrowing Needed, if Any to Meet our Minimum Cash Requirement. Make Sure to Borrow Enough to Cover an Interest Payment. Borrowing Must be Done in 1,000 Dollar Increments Compute the Cost of Interest for One Month at 6% Annual Interest, Using the Amount Financed, if Any? Compute the Budgeted Net Cash Flow, that Flowed in or Out of the Business For the Months Activity, do not include Financing Amounts. Compute the Budgeted Net Income for the Month. Using the Contribution Income Statement Method, Compute the Dollar Difference Between the Budgeted Net Income and Budgeted Net Cash Flow 1,000 Dollar Increments Compute the Cost of Interest for One Month at 6% Annual Interest, Using the Amount Financed, if Any? Compute the Budgeted Net Cash Flow, that Flowed in or Out of the Business For the Months Activity, do not include Financing Amounts. Compute the Budgeted Net Income for the Month, Using the Contribution Income Statement Method. Compute the Dollar Difference Between the Budgeted Net Income and Budgeted Net Cash Flow

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

Effective Auditing For Corporates Ensuring That All The Risks Are Covered

Authors: Bloomsbury, Joe Oringel

1st Edition

1849300445, 978-1849300445

More Books

Students also viewed these Accounting questions

Question

=+ (c) Show that if & is countable, then f(. ) is countable.

Answered: 1 week ago

Question

Identify how culture affects appropriate leadership behavior

Answered: 1 week ago