Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the Following Information to Answer the Questions Below The JWOL Corp is preparing their Cash Budget for the Upcoming Month of JUNE. Given the

Use the Following Information to Answer the Questions Below The JWOL Corp is preparing their Cash Budget for the Upcoming Month of JUNE. Given the Following; 1. The Corp Estimated that they will PRODUCE 1,000 Bikes and SELL 800 Bikes During the month. 2. The Sales price per Unit is $150 Each per Unit 1.80% of All Sales are on Credit and 20% are Cash Sales. 2.25% of the Credit Sales are collected during the current month and 75% are collected later. 3. Costs Include; 1. Direct material = $20 per unit, Direct Labor=$50 per unit 2. Sales Related Costs =$40 per unit 3.75% of All Variable Costs are paid during the current month and 25% are paid in the Next Month. 4. Manufacturing Salaries = $7,000 per month 5. Factory Rent Costs = $6,000 month. 6. Machinery Depreciation= $5,000 per month 7. SGA Costs = $3,000 per month 8. All Fixed Costs are paid for During the month incurred 4. The Corp Plans To Purchase some new Equipment with Cash during the Month for $11,000. 5. The Estimated Cash Balance for June 1st =$44,000 and the minimum Cash required = $40,000. 6. The Corp can Borrow cash from the Bank at a Rate of 6% via a Line of Credit in 1,000 Increments. Please Answer the Questions Below. Enter All Numbers as Numbers Only with NO Commas, Decimals, Dollar Signs or Other Symbols. Show a Negative Number with Parens as Follows = -10 = (10) 5.Compute the Budgeted End Cash Balance Excess or (Deficiency), Before Any Financing for the Month. = (25500) 6.Compute the Amount of Borrowing Needed, if Any = 66500 a. Make Sure to Borrow enough to Cover any Interest Payments and the Minimum Cash Requirements and Borrowing Must be Done in 1,000 Dollar Increments. 7.Compute the Cost of Interest for One Month Using the Amount Financed from Above. = 333 8. Compute the Budgeted Net Cash Flow, IN or (OUT) of the Business

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

Cima Official Learning System Fundamentals Of Business Mathematics

Authors: Graham Eaton

4th Edition

1856177831, 978-1856177832

More Books

Students also viewed these Accounting questions

Question

Explain the sources of recruitment.

Answered: 1 week ago

Question

Differentiate sin(5x+2)

Answered: 1 week ago

Question

Compute the derivative f(x)=1/ax+bx

Answered: 1 week ago

Question

What is job enlargement ?

Answered: 1 week ago