Prepare a cash budget showing the months and quarter

Assignment Help Managerial Accounting
Reference no: EM13496044

Lucy's Gourmet Basket shop is planning to open for business on July 1, 20XX and she is concerned about  the survivability of her company. She has contacted you to prepare operating budgets for the  quarter ending September 30, 20XX. She would like the budgets set out in monthly and quarterly columns for this time period. This business is a merchandising business  so you do not need to worry about the manufacturing of the gourmet baskets.

Sales:
July 8,000
August 9,000
September 12,000
October 10,000

Selling Price
$58

Ending inventory should be 
16% of next months sales demand in units
Beginning Inventory, July 1
0

Purchase price of baskets
$34

Payment of purchases
48% Paid in month of purchase



52% Paid in month after purchase

Projected Cash Sales and collection history of the credit sales is as follows:
23% Cash sales in the month of sale
48% Sales Collected in following month***based on total sales revenue for the month
27% Sales Collected in Second month following sale
1% is deemed uncollectible and therefore will not be shown as cash inflow but is factored into the calculation of net sales
99%

Monthly Selling , general, and administrative expenses are estimated using the flexible budgeting formula as follows:
Fixed Variable ****Variable operating expenses are based on number of units sold
Sales Personnel Salaries $4,000 ****All selling, general, and administrative expenses are paid in the month incurred
Sales Commission $2
Media Advertising $1,000
Facility Rent $1,800
Insurance related to operations $300

In August, the company plans to purchase equipment using cash.
They plan to pay cash of: $18,000

At the present time, the company does not have a required minimum balance and does not have an open line of credit with any bank. Therefore, you do not need to show these sections on your cash budget. Planned beginning balance in cash $25,000

Prepare the following budgets for the three-month period ending September 30.
The text illustrates an annual budget, but you will be preparing a quarterly budget.
Develop your budgets on the sheet entitled budget. Use this sheet as your data for all of your cell referencing.

1. Sales budget, by month and quarter. See page 355 Schedule 1

2. A cash receipts budget from sales, by month and quarter. See page 362 Schedule 7 I like to develop this budget right after the sales budget, since these budgets are related.

3. A merchandise purchases budget in units and in dollars, by month and quarter.

I have set up a formatted budget for you. You can see how I have adapted this budget to Schedule 3 on page 357.

This company is not producing the product but must buy the baskets to sell to customers.

Make sure you think about the numbers you use in the quarter column. I am specifically talking about how you handle beginning and ending inventory, since the BI and EI should not be added across.

4. Prepare a Selling, General, and Administrative Expense Budget, by month and quarter. See page 361

5. A Cash Disbursements Budget, by month and quarter. See page 363 Schedule 8

6. Prepare a cash budget showing the months and quarter.

You can reference schedule 9 page 365, but I have this budget set up differently to track the cash balance monthly and quarterly.
Lucy's Gourmet Basket shop is planning to open for business on July 1, 20XX and she is concerned about the survivability of her company. She has contacted you to prepare operating budgets for the quarter ending September 30, 20XX. She would like the budgets set out in monthly and quarterly columns for this time period. This business is a merchandising business so you do not need to worry about the manufacturing of the gourmet baskets.

Sales:
November 12,000
December 12,900
January 13,800
February 14,700

If you have linked everything correctly, you should only have to change the purchase price and selling price on this sheet to determine your answer to the questions asked.

Reference no: EM13496044

Questions Cloud

Advantage of season changes in the united states : Advantage of season changes in the United States
Delivers pizza to college dormitory rooms : The manger of a restaurant that delivers pizza to college dormitory rooms
Define diameter of a sphere and determined the average value : 4- A student measured the diameter of a sphere and determined the average value. His measyrements are 5.17cm , 5.16 cm cm and 5.17 cm if the diameter is 6.18cm what can be said about the student's results
Determine the magnitude of the acceleration of the train : The train passes point A with a speed of 30 m/s and begins to decrease its speed at a constant rate of at = -0.25 m/s2. Determine the magnitude of the acceleration of the train
Prepare a cash budget showing the months and quarter : Lucy's Gourmet Basket shop is planning to open for business on July 1, 20XX and she is concerned about  the survivability of her company. She has contacted you to prepare operating budgets for the  quarter ending September 30, 20X..
The population mean monthly service fee in dollar : The following data represent the monthly service fee in dollars if a customer's account falls below the minimum required $1,500 balance for a sample of 26 banks
What is the kinetic energy of the projectile : a 2.0kg projectile if fired with initial velocity components Vox= 30 m/s and Voy= 40 m/s from a point on the earth's surface. What is the kinetic energy of the projectile
Explain the same electron configuration in the ground state : which two ions have the same electron configuration in the ground state (a) Rb+ and Ca+ (b) Ba2+ and I- (c) Se2+ And I- (d) Fe2+ and Fe3+
How high will tarzan and jane go on their first swing : Tarzan has foolishly gotten himself into another scrape with the animals and must be rescued once again by Jane. How high will Tarzan and Jane go on their first swing

Reviews

Write a Review

 

Managerial Accounting Questions & Answers

  Role of performance measures-functions of managerial

The Vice President of Operations would like to increase profitability, improve customer service, and expand the business. Discuss the role of performance measures in an organization.

  1 the globalization of business activity has resulted in

1. the globalization of business activity has resulted in which of the following?a.nbsp increased corruption and

  Define financial accounting and managerial accounting

Why do product-costing systems using the direct method, sequential method, and reciprocal method allocate service department overhead costs first to the production departments before assigning them to individual jobs

  Good earth products produces orange juice and candied

good earth products produces orange juice and candied orange peels. a 1000 pound batch of oranges costing 500 is

  Prepare a make or buy analysis

Prepare a make or buy analysis showing the annual advantage or disadvantage of accepting an outside supplier's offer.

  Microimage technology inc produces miniature digital color

microimage technology inc. produces miniature digital color cameras that can be attached to endoscopes and other

  Cvp analysis of plainfield bakers

Plainfield Bakers manufactures and sells the popular line of fat free cookes under name Aunt May's cookies. The process Plainfield employs to manufacturer the cookies is labor-intensive; it relies heavily on direct labor.

  Flexible budget-cost-volume-profit analysis

Describe how a flexible budget lends itself to cost-volume-profit analysis.

  What makes a contribution income statement unique

Show what makes a contribution income statement unique and discuss how a contribution income statement could be used to improve planning in a company.

  Suitable price per meal for the auditorium

What would be a suitable price per meal for the auditorium to continue to have the Season's Restaurants supply meals? Explain your answer?

  Computer-based document processing service

Process Solutions provides a computer-based document processing service

  Strategic management principles and technologies

use strategic management principles and technologies in making and assessing business decisions for profit and not for profit organisations and evaluate and use quantitative and qualitative information to measure financial and non financial perfor..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd