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

Accountingimagine that you are a consultant working on a

Accounting Imagine that you are a consultant working on a special project to help a company determine techniques that it can use in order to calculate the fair value of investments. From the e-activity, prepare a report ...

Managerial accounting and financial accountingcompare and

Managerial Accounting and Financial Accounting Compare and Contrast Managerial Accounting and Financial Accounting. Be sure to discuss how managerial accounting is useful for providing information for at least one of the ...

Auerbach enterprisescomplete case 3a auerbach

Auerbach Enterprises Complete: Case 3A (Auerbach Enterprises). Auerbach Enterprises manufactures air conditioners for automobiles and trucks manufactured throughout North America. The company designs its products with fl ...

Expl principles of accountingdepartment Expl Principles of Accounting Department

Expl Principles of Accounting Department Responsibility • Why should responsibility for related transactions be divided among different departments or individuals? Do you agree the transactions should be divided? Why or ...

Reading concept summaryno plagiarism must be original

Reading Concept Summary **NO PLAGIARISM. MUST BE ORIGINAL. PLEASE USE REFERENCES IF NEEDED ** Write a 260- to 350-word summary of this week's readings. Please write about the following: Fixed Assets, Depreciation, and In ...

Question 1the following transactions occurred during july o

Question 1 The following transactions occurred during July: o Received $900 cash for services provided to a customer during July. o Received $2,200 cash investment from Barbara Hanson, the owner of the business. o Receiv ...

Brief exercise 17-3carow corporation purchased as a

Brief Exercise 17-3 Carow Corporation purchased, as a held-to-maturity investment, $70,500 of the 10%, 7-year bonds of Harrison, Inc. for $77,947, which provides a 8% return. The bonds pay interest semiannually. Prepare ...

Q1 in each of the following independent situations

Q1: In each of the following independent situations, determine how much should be included in Burton's gross estate less than 2042 as to the various life insurance policies involved. Assume that none of the policies are ...

Accounting assignmentplease include all calculationswork

Accounting Assignment Please include all calculations/work necessary. Please show references and in-text citing where needed. Please answer all questions in full. No plagiarism. For the eActivity, research one publicly t ...

Write a 700- to 1050-word summary of your teams discussion

Write a 700- to 1,050-word summary of your team's discussion regarding IFRS versus. GAAP. The summary should be structured in a subject-by-subject format. Include an introduction and a conclusion. Your discussion should ...

  • 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