Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

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

Accounting for business decisions group assignment the

Accounting for Business Decisions Group Assignment The assignment will require the group to undertake research using the website of the Australian Stock Exchange (ASX) and/or the Company whose industry is Food, Beverage ...

Presentation on cybercrimemayfield electronics inc an

Presentation on CyberCrime Mayfield electronics, Inc., an international company has asked your accounting firm to share with its employees the threat of cybercrime and how the company can protect itself corporately as we ...

Question 1 - the transactions of gb bhd for the month of

QUESTION 1 - The transactions of GB Bhd for the month of December are as follows: Date  (December 2015) Transactions 1 Paid insurance premium of RM10,000 for coverage against losses due to fire for a period of 36 months. ...

A strong 1 page paper with references forbased on the

A strong 1 page paper with references for Based on the scenario presented in the Learning Team Instructions, write a 1-page report on your IT Audit and Control Analysis Plan. Draft answers to the following: • Why conduct ...

Case study -you are auditing the financial report of best

Case Study - You are auditing the financial report of Best Living Supplies Ltd (Best Living Supplies) for the year ended 30 June 2016. Best Living Supplies sells a wide variety of household products to retail outlets. Al ...

Final project budget variance reportintroduction-in your

Final Project Budget Variance Report Introduction- In your opening paragraph, very briefly introduce the purpose of your paper. Recall that you will be discussing the operating budget and variance analysis as explained i ...

Accounting theory assignment-read the articles on study

Accounting Theory Assignment- Read the articles on study desk: Volkswagen The scandal explained Instructions This assignment is a research based essay where you are required to relate a practical example to accounting th ...

Fill in the amounts for x y and z in the following table

Fill in the amounts for X, Y, and Z in the following table. (The company started business on January 1, 2009 31-Dec-09 31-Dec-10 Assets $4,750 $5,350 Liabilites 2150 $1,400 Cantributed Capital $1,200 $1,200 Retained earn ...

The assignmentmost of our cases will involve some form of

The Assignment: Most of our cases will involve some form of role-playing. In other words, they won't be student-to-teacher case write-ups. In this case I am also playing a role. I am Chairman of ABC-VC, a venture capital ...

Accounting management and cost decisionsproduct costing

Accounting, Management, and Cost Decisions Product Costing Systems For the list of product manufacturers below, indicate whether a job-cost system (J) or a process cost system (P) would be most  appropriate. a. Chemicals ...

  • 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