Prepare a memo with recommendations regarding budget

Assignment Help Financial Accounting

Reference no: EM135977

Perfect Gas Corporation supplies compressed gases to business customers. Data regarding the store's operations given:

Sales are budgeted at $345,000 for November, $230,000 for December, and $320,000 for January.
Collections are expected to be 60 percent in the month of sale, 34% in the month subsequent the sale, and 6% uncollectible.
The cost of goods sold is 70% of sales.
The company desires ending merchandise inventory to same 80% of the subsequent month's cost of goods sold. Payment for merchandise is made in the month subsequent the purchase.
Other monthly expenses to be paid in cash are $12,000.
Monthly depreciation is $16,000.
Equipment purchases of $110,000 were paid in cash in November.
Dividends of $35,000 were declared and paid in December.
Any borrowings must be in $1,000 increments at 7 percent interest. Consider interest accrues at the starting of the month and is paid at the end of the month. The company must maintain a minimum cash balance of $5,000.
Ignore income taxes.

Prepare the subsequent budgets for November and December and total for the two months in good form in excel.

a. Create a Schedule of Expected Cash Collections

b. Purpose a Merchandise Purchases Budget

c. Plan Cash Budgets

d. Prepare Budgeted Income Statements

e. Purpose a Budgeted Balance Sheet

Purpose a letter/memo to the company's CEO with specific recommendations regarding your budget.

Reference no: EM135977

Questions Cloud

Evaluate the npv of the project : The subsidiary will be sold at the end of three years for an estimated €9.9 million. evaluate the NPV of the project?

Evaluate the companys wacc : You are given the subsequent information for Lightning Power Co. Suppose the company's tax rate is 40 percent. evaluate the company's WACC

What characteristic of the synthetases explains discrepancy : What characteristic of the synthetases explains this discrepancy. Tina is consuming 15 mg of iron per day. Her RDA is 18 mg. She has no condition warranting a greater-than-normal need for iron. Which of the statements is true about her consumption of..

Increase profits by practicing price discrimination : A pharmaceutical firm faces monthly demands in the U.S. and Mexican markets for one of its patented drugs.

Prepare a memo with recommendations regarding budget : Purpose a letter/memo to the company's CEO with specific recommendations regarding your budget.

Reliability of the data for making investment decision : Based on your review of the financial data for every company, show the accuracy and reliability of the data for making investment decision.

Determine the total gross deductions : Evaluate the total Gross estate and determine the total gross deductions?

How various molecules does one mole of table sugar : In maize, a dominant allele (A) is essential for seed color as opposed to colorless (a). Another gene has a recessive allele (w) which results in waxy starch, as opposed to normal starch (W).

What could be deduced from these data about the structure : The membrane vesicles are next washed, the membranes solubilized and the proteins denatured and analyzed by SDS gel electrophoresis and Western blotting using polyclonal antibodies against glycophorin A, an erythrocyte plasma membrane protein.

User Account

All Pages