Brighton inc manufactures kitchen tiles the company

Assignment Help Financial Accounting
Reference no: EM13376237

Brighton, Inc. manufactures kitchen tiles. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. In considering the loan, the bank requested a projected income statement and cash budget for Q2 (April, May and June).

The following information is available:

-The company budgeted sales at 600,000 units per month in April, June, and July and at 450,000 units in May and August. The company sold 500,000 units in March. The selling price is $4 per unit.

-The beginning Cash balance at 4/1 is $400,000.

-Accounts Receivable balance at 3/31 is $100,000. 75% of this balance will be collected in April and 25% of the balance will be collected in May.

-All sales are credit sales. Collections from customers are projected as follows:

-50% of current month sales are collected

-25% of current month sales are collected in the following month.

-24% of current month sales are collected in the second month following the month of sale.

-1% of sales are never collected.

- The inventory of finished goods on April 1 was 120,000 units. The finished goods inventory at the end of each month equals 20 percent of sales anticipated for the following month. There is no work in process.

-The inventory of raw materials on April 1 was 57,000 pounds. At the end of each month, the raw materials inventory must equal 40 percent of production requirements for the following month.

-Purchases made in the current month are paid for in the following month. The company purchased 100,000 pounds of material during the month of March.

-Selling expenses are 10 percent of gross sales. Administrative expenses, which include depreciation of $2,500 per month on office furniture and fixtures, total $165,000 per month.

-The manufacturing budget for tiles, based on normal production of 500,000 units per month, follows:

Using the MS Excel template provided, prepare the projected income statement and cash budget along with the following supporting schedules for the bank:

· Sales Budget
· Production Budget (in units)
· Raw Materials Budget
· Direct Labor Budget
· Manufacturing Overhead budget
· Selling & Administrative Budget
· Projected Cash Collections
· Projected Cash Disbursements

You will also note that there are FOUR questions on the front tab of the Excel Workbook (Income Statement Tab). The questions are highlighted in YELLOW. Please provide a short answer for each of these questions after completing the spreadsheets.

You will submit the COMPLETED MS Excel Workbook to DROPBOX as your case submission.

CHECK FIGURES:
-Total Operating Profit (Income Statement Tab) $552,947
-Ending Cash Balance (Cash Budget Tab) $236,500
-Total Production in Units (Production Budget Tab) 1,650,000
-Total Raw Material Cost (in $) (Raw Materials Budget Tab) $1,650,000
-Total Manufacturing Overhead Cost (Mfg Overhead Tab) $1.860,000
-Total Cash Disbursements (Cash Disbursements Schedule) $5,189,500

Reference no: EM13376237

Previous Q& A

  Timbuk 3 inc has finished a new video game snowboard

timbuk 3 inc. has finished a new video game snowboard challenge. management is now considering its marketing

  On june 30 2013 georgia-atlantic inc leased a warehouse

on june 30 2013 georgia-atlantic inc. leased a warehouse facility from ic leasing corporation. the lease agreement

  Hand-made furniture company manufactures sofas for

hand-made furniture company manufactures sofas for distribution to several major retail chains. the following costs are

  Impulse pty ltd impulse is an entertainment system

impulse pty ltd impulse is an entertainment system manufacturer that was established in 2005. your audit firm king amp

  Overview1 created a document describing the business and

overview1. created a document describing the business and identifying the problems being experienced by the assignment

  Part-1for task 1 list the things you changed and the

part-1for task 1 list the things you changed and the purpose of changing it. good reasons include making code easier

  Hyundai case studycommon case focuses on the operations of

hyundai case studycommon case focuses on the operations of hyundai the korean automobile manufacturer in china. the

  Question 1 entity-relationship er model create an er

question 1 entity-relationship er model create an er diagram using the set of requirements provided for oxford city

  Write a program that allows a user to enter a line of text

write a program that allows a user to enter a line of text counts number of words and number of vowels in the sentence

  What do prion and virus have in common what do capsid and

what do prion and virus have in common? what do capsid and prion have in common? what do virus and retrovirus have in

Reviews

Write a Review

 

Similar Q& A

  Intent and ability to hold investments until maturity

1. Prepare the journal entry to record Fuzzy Monkey's investment on January 1, 2013

  Discuss the accounting this company uses to allocate cost

Once you identify a company with a specific asset, discuss the accounting this company uses to allocate the cost of that asset to the periods benefited from its use.

  Reliability of the data for making investment decision

Based on your review of the financial data for every company, show the accuracy and reliability of the data for making investment decision.

  What balance should appear in the investment in holister

Assuming Alison uses the equity method, what balance should appear in the Investment in Holister account as of December 31, 2011?

  Construct mannys budgeted cost of goods

Write a brief report explaining possible reasons why Manny's profits were different from the amount projected in the master budget for September - Construct Manny's budgeted cost of goods sold and operating income statement for December and the tota..

  Illustrate what account was debited to amortize the discount

What is the unamortized amount of the discount or premium account at the beginning of the period? Illustrate what account was debited to amortize the discount or premium?

  Concept of accounting for merchandise through short

concept of accounting for merchandise through short questions and journal entries.1.nbspon june 1 20x1 jordan company

  Journalize the transactionsnbsp from the given

journalize the transactionsnbsp from the given information.journalize the following merchandising transactions for csi

  Prepare the journal entry to record the exchange

Why it is it important to distinguish between expenses that need to be capitalized and expenses that need to be expensed.

  Preparation of cash budget and interpreting the cash

preparation of cash budget and interpreting the cash position of the company.grenoble enterprises had sales of 50000 in

  Prepare the adjusting entry to recognise bad debt

prepare the adjusting entry to recognise bad debt expense.the montgomery burns company had a 700 credit balance in

  Determine the amount of indirect manufacturing costs

Determine the amount of indirect manufacturing costs allocated to one engine of each type (Basic, Heavy Duty) based on the existing cost allocation basis

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd