Fill in order details

  • Submit your instructions
    to writers for free!

Chat with the writer

  • Chat with preferred expert writers
  • Request a preview of your paper
    from them for free

Editing

  • Project edited by the quality evaluation department

Download Your Completed Project

  • Download the completed project from your account or have it sent to your email address

Read Part I of the case carefully and create a spreadsheet page for data input as you go. This is where you will find all the numbers necessary to create your budgets as you move through the case.

The Case Study: Buns Bakery. Refer to attached file: Buns Bakery Case Study.

Required: Part 1.

Read Part I of the case carefully and create a spreadsheet page for data input as you go. This is where you will find all the numbers necessary to create your budgets as you move through the case. It is important that you think through what numbers you will need and lay those out logically with clear labels. This serves two purposes:first, it will make it easier to create the budgets, and second, when you turn this budget over to management, they may wish to change some of the assumptions and see what results flow through the budget. To this end, you must show all assumptions on the first worksheet.

You will need to create the following items:

  1. Data Input Sheet
  2. Cash Flows Budget
  3. Production Budget
  4. Projected Balance Sheet
  5. Projected Profit and Loss Statement
  6. Sales Budget

Youmayalsoneedtocreatesupportingschedulesandtables. Pleasegroupthese logically on worksheets within your document and label the tabs so that the owners and managers can find whatever budget or schedule they need. Think about the logical order of budgets. Your data input sheet should be the first worksheet. What should be the second worksheet? Make the spreadsheet document flow logically.

Have the spreadsheet show most dollar amounts as whole dollars (in some cases, such as the price of an ingredient at $0.15, it won’t make sense to do so –use your judgment). Similarly, use your judgment on how many decimals to display and what format to use ($ or % for example) in each cell. Remember, that the calculations will still be accurate as Excel uses the decimal part of the number even if it isn’t showing. Also, a good use of bold, italics, colour, and borders will make the spreadsheet more visually appealing and, if used correctly, easier to understand and use.

As a check for you, the Profit after Tax for the budget year should equal $67,524, the closing balance of Accounts Receivable should be $951,766, the closing balance of Raw Materials Inventory should be $38,465, and the cash on hand at the end of the budget year should be $46.074.

Part 2

Read Part II of the case carefully. Using the Master Budget you created for Part I of the project, answer the following questions:

  1. What will Buns’ Earnings Per Share, cash flow from operations, and profit margin be for each of the options?
    1. Increase the sales commissions to 2%;
    2. Move to a JIT inventory system, keeping only 3% of the needed raw materialson hand;
    3. Improve the collections rate to 80% in the first quarter, 15 % in the secondquarter, and 5% in the third quarter;
    4. Revise the price increase to reduce the impact on sales volume.
  2. If Buns can only make one of the proposed changes, which change do you recommend the company make? Explain? Provide as much supporting argument and analysis as appropriate in support of your recommendation.
  3. If Buns can make two of the proposed changes, which two do you recommend the company make? Explain. Provide as much supporting argument and analysis as appropriate in support of your recommendation.
  4. Provide two additional changes Buns could make to improve its pro forma financial statements. This is an opportunity for you to think creatively and to show your understanding of the relationship between various parts of the operation.
  5. Would you invest in Bun’s Bakery after seeing theoriginal numbers? What about after the changes had been made in question 2? In question 3? Provide an explanation in support of your position.
  6. Task Length: 2,000 words (excluding tables, spreadsheets and references).

Place your order now on a similar paper and get best quality work written by our expert level writers. “A” guaranteed.

assignment writing help

What our customers say
_____

Ishita M.Ishita M.
Great Job! Thank you so much for your work. You got it done faster than I imagined and everything is perfect. Will definitely be using you again!
Megan J.Megan J.
"As a wife, mother, and full-time student, I was struggling to try to go back to school and take care of my responsibilities. Sometimes you just need a little help, and I appreciate all the help I have gotten from Academic Research Bureau. My papers are on-time and the writers are easy to work with. Thanks for the support!"
Rajab M.Rajab M.
Universitywritingservices.com has saved me a lot of time. I was tired of taking the same classes many times over again. As an ESL student, my professors were taking points off of my assignments for my grammar mistakes. It made it very hard to feel encouraged to continue with my studies. Thankful for having found an answer for better grades."
Frank N.Frank N.
As a working student, I just really don't have the time to write paper after paper and complete assignment after assignment. Working full-time and going to school was nearly impossible until I was able to feel comfortable with the writers on this site. They make me feel secure enough to trust them with my papers. While I'm busy with life, they are busy writing my papers. They always do an outstanding job!
Courtney B.Courtney B.
Thank you! You were really patient with me and my needs. This was my first time using you guys, however, I will definitely be using you again!
John H.John H.
I cannot tell you enough how amazing your company is! Your writers are superb, on time, excellent content, so very thankful you reached out to me that day! Lifesaver for sure! Couldn’t be happier with the results I’ve gotten from my first 2 papers with you, I have 4 papers left to go and I’ll be using your company for them all!
Rebecca T.Rebecca T.
After I ordered a dissertation from your writing service, the first paper that I was given did not met my professor’s demand. I set the paper on revision and the writer made the revision for free meeting all my requirements and I was very satisfied
Thomas R.Thomas R.
I was shocked by how your writers managed to deliver my paper on time, and I was among the best in our class in that paper. Thank you so much and I will never hesitate to use you
error: protected!!