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 case studyplease provide the answers to these

Accounting Case Study: Please provide the answers to these questions in the form of a paper. Please ensure the paper and all paper references are in APA format. CASE: Evaluating a Company's Budget Procedures. Tom Emory a ...

Assignment descriptiona manufacturing company is thinking

Assignment Description A manufacturing company is thinking of launching a new product. The company expects to sell $950,000 of the new product in the first year and $1,500,000 each year thereafter. Direct costs including ...

Assignmentpart iexplain what you learn about the

Assignment PART I Explain what you learn about the disclosures of your SEC 10-K company relating to Income Taxes. Your comments should relate to net income or loss as well as to the balance sheet treatment and disclosure ...

In january 2013 mitzu co pays 2650000 for a tract of land

In January 2013, Mitzu Co. pays $2,650,000 for a tract of land with two buildings on it. It plans to demolish Building 1 and build a new store in its place. Building 2 will be a company office; it is appraised at $823,50 ...

1it has been suggested that it is not possible to determine

1. It has been suggested that it is not possible to determine the point at which financial accounting and managerial accounting diverge. What does that mean? Your response should be at least 200 words in length. For prob ...

Question 1 tonys textile company sells shirts for men and

Question 1: Tony's Textile Company sells shirts for men and boys. The average selling price and variable cost for each product are as follows: Men's Boy's Selling Price $28.80 Selling Price $24.00 Variable Cost $20.40 Va ...

Ics manufacturing company produces plastic parts for the

ICS Manufacturing Company produces plastic parts for the automotive industry. Here is their Income Statement for 2015 - ICS Manufacturing Company Income Statement for 2015 Sales Revenue $35,500,000 Cost of Goods Sold 12, ...

Assignment change modelassume you are the sales and

Assignment Change Model Assume you are the Sales and Marketing Director for Sea Treasures, a small group of well-known retail stores specializing in exotic sea life and high-end accessories for aquariums. The company has ...

Westerville company reported the following results from

Westerville Company reported the following results from last year % 2013 operations: Sales $ 1,000,000 Variable expenses 300,000 -------------------------------------- Contribution margin 700,000 Fixed expenses 500,000 - ...

As you begin this assignment review the broad range of

As you begin this Assignment, review the broad range of topics presented throughout the course related to using accounting information for decision making. Clearly, 8 weeks does not provide enough time to explore all 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

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