Ask Question, Ask an Expert


Ask Accounting Basics Expert

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

• Sales are budgeted at $345,000 for November, $230,000 for December, and $320,000 for January.

• Collections are expected to be 60% in the month of sale, 34% in the month following the sale, and 6% uncollectible.

• The cost of goods sold is 70% of sales.

• The company desires ending merchandise inventory to equal 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following 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% interest. Assume interest accrues at the beginning 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 following budgets for November and December and total for the two months in good form in excel and submit via bblearn by 5/9 at noon:

a. Prepare a Schedule of Expected Cash Collections

b. Prepare a Merchandise Purchases Budget

c. Prepare Cash Budgets

d. Prepare Budgeted Income Statements

e. Prepare a Budgeted Balance Sheet

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

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M945752

Have any Question? 

Related Questions in Accounting Basics

Assignment- fraud in the accounting information systemfor

Assignment- Fraud in the Accounting Information System For this assignment, research the Internet or Strayer databases to locate a firm that was involved in a fraud and / or embezzlement case. Explain how the firm's acco ...

Key information for the plant city divisionkey information

Key Information For The Plant City Division Key information for the Plant City Division (PCD) of Barkley Industries for 2015 are as follows: Revenues $15,000,000 Operating Income 1,800,000 Total Assets 10,000,000 PCD man ...

Discussionaccounting irregularities please respond to the

Discussion "Accounting Irregularities" Please respond to the following: • Imagine that you were auditing accounts receivable balances to confirm sales and found significant discrepancies between the recorded account bala ...

Exercise recording receivables and identifying their effect

Exercise: Recording receivables and identifying their effect on financial statements Davos Company performed services on account for $160,000 in 2016. Davos collected $120,000 cash from accounts receivable during 2016, a ...

1 a psychologist studied the number of puzzles subjects

1. A psychologist studied the number of puzzles subjects were able to solve in a five minute period while listening to soothing music. Let X be the number of puzzles completed successfully by a subject. X had the followi ...

International accountingpart 1the weeks discussion covered

INTERNATIONAL ACCOUNTING PART 1 The week's discussion covered the following International Accounting Standards (IAS): #21 The Effects of Changes in Foreign Exchange Rates #27 Consolidated and Separate Financial Statement ...

A tractor acquired on january 4 of the current year at a

A tractor acquired on January 4 of the current year at a cost of $100,000 has an estimated life of 10 years. Assuming that it has a residual value of $10,000, determine the depreciation expense in the current year using ...

Accountingthe accepted microsoft office versions for this

Accounting The accepted Microsoft Office versions for this assignment are Microsoft Office 2013 (for PC) and Microsoft Office for Mac 2011 (for Macintosh). Students may use a more recent version if available. Select a pe ...

Assignmentas the accounting period comes to an end you will

Assignment As the accounting period comes to an end, you will prepare the adjusting and closing entries, as well as prepare the financial statements for Marabelle's Craft 'n Shop. Please use this template to complete you ...

Assume a local subway reported the following results for

Assume a local Subway reported the following results for April and May August September Unit Sales      2,000             2,500 Cost of Food Sold  $   1,000  $         1,250 Wages and Salaries      1,525             1,67 ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro