Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please include ALL formulas for excel spreadsheet. THANK YOU!! You have just been assigned to a new manager who believes you have exceptional budgeting skills.

please include ALL formulas for excel spreadsheet. THANK YOU!! image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
You have just been assigned to a new manager who believes you have exceptional budgeting skills. Since you began your job last summer, you have been showing management your latest spreadsheets and how you use your new-found knowledge of Managerial Decision-Making to make sound business decisions. Your new manager is responsible for the nationwide distribution of the newly developed Self Protection Device (SPD), using an ultrasonic sound emission, DNA material capture via a retractable claw, and an amazing 250,000 lumen LED flashing light. Through multiple franchise agreements, sales have grown very rapidly and the timing is right for you to join her team and show your skills. You have just been given responsibility for all of the planning and budgeting of the entire division. Your first assignment is to prepare a master budget for the next three months, starting April 1, 2023. You accept this responsibility with enthusiasm. You are anxious to impress your new manager and the president of the parent company (Allteq Solutions) who has a very high regard for you. To commence your now role, you have assembled the following pertinent information: Note: The company desires a minimum ending cash balance each month of $12,000. The SPDs are sold to retailers for $30 each andd they are flying off the shelves. Recent forecasted sales in An agreement with Bast Rivers Bank allows you to borrow in increments of $1,000 at the beginning of each month, up to a total loan amount of $350,000. The interest rate on these loans is 7% annually (pretty high considering market rates), but the interest is not compounded, meaning this is simple interest only. At quarter end, SPD would pay East Rivers Bank all of the accumulated interest on the loan and as much of the balance of the loan as soon as possible (include $1,000 increments) while retaining the minimum $12,000 cash balance. Fint: use this Bxcel formula to determine the amount needed to borrow: Ifir(excess/deficil

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

Auditing Principles And Techniques

Authors: Sanjib Kumar Basu, Andrei Alexandrescu

1st Edition

8177581783, 9788177581782

More Books

Students also viewed these Accounting questions

Question

c. What groups were least represented? Why do you think this is so?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago