Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need master budget for petco with the following information The CFO wants to get ahead of planning and forecasting and has put you in

I need master budget for petco with the following information image text in transcribed
The CFO wants to get ahead of planning and forecasting and has put you in charge of the deliverable. You and the finance team have one week to provide her with preliminary operational budgets for the next 12 months continuous. You have been provided the following estimates: - Sales will increase 23% in Q1 and increase by 8% in the other 3 quarters. The company does not plan to increase prices in the next 12 months. - COGS will increase each quarter: 12%, 18%,10% and 5% respectively - Total operating expenses are estimated to decrease in the first half of the year by 15% respectively, then increasing by 3% each month thereafter. - If there are outstanding receivables, the company has implemented new procedures that will help them collect 35% of the prior year's accounts receivable balance. They expect to collect the 35% equally over the fiscal year. increase by 8% in the other 3 quarters. The company does not plan to increase prices in the next 12 months. - COGS will increase each quarter: 12%. 18%,10% and 5% respectively - Total operating expenses are estimated to decrease in the first half of the year by 15% respectively, then increasing by 3% each month thereafter. - If there are outstanding receivables, the company has implemented new procedures that will help them collect 35% of the prior year's accounts receivable balance. They expect to collect the 35% equally over the fiscal year. Using the information above, prepare a comprehensive master budget for your company (in excel) and prepare a memo (in word, following the template provide Week 1) that explains the potential impact of the business' operational budget. Comment on if any improvements to the budget you believe should be made

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

Entrepreneurial Finance

Authors: J. Chris Leach, Ronald W. Melicher

6th edition

1305968352, 978-1337635653, 978-1305968356

More Books

Students also viewed these Finance questions

Question

What did we learn from the consultantclient relationship?

Answered: 1 week ago