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

You are an accountant at wcp accountants and investment

You are an accountant at WCP Accountants and Investment Advisers. You have been approached by a client for your professional advice on investing in Woolworths Ltd. Your client supports Australian made products. Your clie ...

Practice questionsfour years ago your uncle mike set up a

Practice questions: Four years ago. your Uncle Mike set up a small manufacturing company. Aphrodite Showers. in Cyprus which manufactures shower screens. There are two models: the Paphos. which is the standard model. and ...

Horizontal and vertical analysisfor this assignment due in

Horizontal and Vertical analysis For this assignment, due in Module Four, you will submit both a horizontal and vertical analysis of Starbucks' accounts receivable, fixed assets, and debt financing. Use basic financial a ...

Classifying costs in a service companya partial list of the

Classifying costs in a service company A partial list of the costs for Wisconsin and Minnesota Railroad, a short hauler of freight, follows. Classify each cost as either indirect or direct. For purposes of classifying ea ...

Assignmentnbsp the eatery is a restaurant in dekalb

Assignment  The Eatery is a restaurant in DeKalb, Illinois. It specializes in deluxe sandwiches in a moderate price range. Michael Raye, the manager of The Eatery, has determined that during the last two years the sales ...

Identify and explain the inventory asset and cost flows of

Identify and explain the inventory asset and cost flows of a merchandising company. Provide examples.

Primary task response within the discussion board area

Primary Task Response: Within the Discussion Board area, write 300-400 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your cla ...

Imagine you are a member of the project approval committee

Imagine you are a member of the project approval committee. An ambitious young manager in the marketing department is well connected with the top management team in your company. He catches you in the hall and mentions t ...

Practice questionswhat influences have encouraged new

Practice questions: What influences have encouraged new developments in management accounting?

Financial statement fraud and other types of fraudread the

Financial Statement Fraud and Other Types of Fraud Read the following problems and respond according to the instructions at the end. 1. How is fraud committed on behalf of an organization (such as financial statement fra ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate