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

Discussionpart 1 please respond the following question no

Discussion PART 1 PLEASE RESPOND THE FOLLOWING QUESTION NO LESS THEN 350 WORDS (ORIGINAL WORK, NO PLAGIARISM, 1 Reference "Negative Cash Flow" Please respond to the following: • Assess how the free cash-flow method can b ...

1 what does it mean to create a culture of honesty openness

1. What does it mean to create a "Culture of Honesty, Openness, and Assistance?" Give some examples from an organization with which you have been affiliated. (250 words) 2. Review the section Preventing Fraud-A Sumary an ...

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

Write a 700- to 1,050-word summary of the team's discussion about IFRS versus GAAP, based on your team collaborative discussions. The summary should be structured in a subject-by-subject format. An introduction and a con ...

Last year cmc recorded a deferred tax asset related to

Last year, CMC recorded a deferred tax asset related to product warranties and a deferred tax asset related to accelerated depreciation. A 75% valuation allowance was also established. However, with an upcoming internati ...

Accountingbulluse the internet to research an annual report

Accounting • Use the Internet to research an annual report of a retail company. • Then, imagine you are an investor or creditor; suggest the ratios that you believe would provide an investor or creditor with the most imp ...

Accounting assignmentgrant film products wishes to expand

Accounting Assignment Grant Film Products wishes to expand and has borrowed $100,000. As a condition for making this loan, the bank requires that the business maintain a current ratio of at least 1.50. Business has been ...

Business assignmentthe comany i have choosen is upsresearch

Business Assignment The comany i have choosen is UPS. Research a company that interests you from the Fortune 500. (A list will be provided). Analyze what they do. What business are they in? What industry? How have they b ...

Questionson may 5 2006 disney company completed an all

Questions On May 5, 2006, Disney Company completed an all stock acquisition of Pixar, a digital animation studio. Disney believes that the creation of high quality feature animation is a key driver of success across many ...

1 weighted average cost method with perpetual inventory

1. Weighted average cost method with perpetual inventory (Page 349 of Accounting 25e Warren-Reeve-Duchac) The beginning inventory for RTE Office Supplies and data on purchases and sales for a three-month period are shown ...

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 ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen