How do make a cash budget for september and october

Assignment Help Managerial Accounting

Reference no: EM132690638

Following data and information in order to put together a cash budget for September and October.

Hannah Baker owns and operates Tinapay Inc. which sells a wide variety of cupcakes.

Budgeted sales for September are 65,000 cupcakes and 98,000 in October. Each cupcake sells for P3.50.
On average 60% are cash sales and 40% are sold on account.
The company expects to collect 75% of credit sales in the month of the sale and 20% in the month after the sale.
All necessary raw materials are purchased on account. Purchases are paid 85% in the month of the purchase and 15% in the following month. Purchases for September are estimated to be P200,000 and P290,000 in October.

Monthly expenses include:

Wages P10,000

Rent P4,000

Utilities P3,500

Insurance P2,500

Advertising P2,290

Cash balance on September 1st was P6,000.
The company has a policy to maintain a minimum cash balance of P5,000. If necessary, the company will borrow to meet its short-term needs. All borrowing is done at the beginning of the month and all payments on principal and interest are made at the end of the next month. The annual interest rate is 7%. The company must borrow in multiples of P1,000.
August sales were 43,000 cupcakes and raw materials purchased equal P230,000.

Question 1: Make a cash budget for September and October.

Reference no: EM132690638

Questions Cloud

Ethical managerial decision making : List the three factors that influence ethical managerial decision making. How do HR managers can influence improve ethical decision making within an organisatio

What will lark total operating income be next year : Lark Company manufactures dog food for distribution in Washington, Oregon. What will Lark's total operating income be next year if it accepts the offer?

What does typical in vitro fertilization treatment entail : What does the typical in vitro fertilization (IVF) treatment entail? How much does it cost? What are the risks to the mother you.

Make a depreciation schedule for the first three years : Make a depreciation schedule for the first 3 years ending 30 June using the diminishing balance depreciation method. Assume the depreciation rate

How do make a cash budget for september and october : Budgeted sales for September are 65,000 cupcakes and 98,000 in October. Each cupcake sells for P3.50. Make a cash budget for September and October.

Describe your physiological and cognitive reactions : In a multi-paragraph essay, first describe your physiological, emotional, behavioral, and cognitive reactions to the stressor of taking exams.

What are your attitudes toward mfipv perpetrators : What are your attitudes toward MFIPV perpetrators? Are your beliefs and attitudes similar to those held by the public at large? Do you believe that batterers.

What is the simple payback period : One of the main uses of TVM concepts is to help a firms CFO and CEO decide. Whats the projects NPV if the firms discount rate or cost of capital is 10%

Identify the advantage of having a balanced scorecard : Diagram a strategy map for a set of CSFs that you have included in your balanced scorecard. Summarize the process that Deb Young used to develop

User Account

All Pages