1 answer

Calculston ME How Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a...

Question:

Calculston ME How Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for

Total cash receipts Less estimated cash payments for Manufacturing costs Selling and administrative expenses Capital expendit

Calculston ME How Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information s September October November Sales $136,000 $170,000 $227.000 Manufacturing costs 57.000 23.000 82,000 Selling and administrative 51,000 48,000 86,00 expenses Capital expenditures 54,000 The company expects to sell about 10 % of its merchandise for cash. Of sales on account, 70 % are expected to be collected in the month following the sale and the remainder the followng month (second month following sale). Depreciation, insurance, and property tax expense represent $6.000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in January and the annual property taxes are paid in December. Of the remainder of the manufacturing costs. 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of September 1 include cash of s52.000, marketable securities of $73.000, and accounts receivable of $151,700 ($119.000 from July sales and $32,700 fram August sales). Sales on account for July and August were $109,000 and $119.000, respectively. Current liabilities as of September 1 include $6.000 of accounts payable incurred in August for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incumed, An estimated income tax payment of $20.000 will be made in October, Bridgeport's regular quarterly dividend of s6.000 is expected to be declared in October and paid in November, Management desires to maintain a minimum cash balance of $51,000. Requireds 1. Prepare a monthly cash budget and supporting schedules for September, October, snd November Input all amounts as positive values except overall cash decrease and deficiency which should be indicated with a minus sign, Assume 360 days per vear for interest caiculations Bridgeport Housewares Inc. Cash Budget For the Three Months Ending November 30 September November October Estimated cash receipts from Cash sales 22.700 17.000 13600 Collection of accounts receivable Total cash recepts Less estimated cash payments for: Manufacturing costs Selling and administrative exxpenses Previous
Total cash receipts Less estimated cash payments for Manufacturing costs Selling and administrative expenses Capital expenditures Other purposes Income tax Dividends Total cash payments Cash increase or (decrease) Plus cash balance at beginning of month Cash balance at end of month Less minimum cash balance Excess or (deficiency) Feeack TONMTon The primanry squrce of eslimeted oash regeiots is from aash seles and oollections on acoount To estimate cash receipts from cash sales and gollections on acoount, a schedule cf.collections trom sales is precared Learning Objective 5 2. On the basis of thee cash budaet prepared in part (1), what recommendation should be made to the controller" of the and/or by the be maintained in Navember, This situation can be corrected by the minimum desired balence, The budget indicates that the minimum cash balance marketeble securities, if they are held for such purnoses. At the end of September and October, the cash balance wl

Answers

Collections of accounts receivable September October November July sales August sales September sales October sales Total cas

Bridgeport Houseware Inc Cash Budget For the Three Months Ending November 30 September October November Estimated cash receip

The budget indicates that the minimum cash balance will not be maintained in November. This situation can be corrected by borrowing and/or by the sale of the marketable securities, if they are held for such purposes. At the end of September and October, the cash balance will be the minimum desired balance.

.

Similar Solved Questions

1 answer
--/1 Question 1 View Policies Current Attempt in Progress Pronghorn Inc. uses a calendar year for...
--/1 Question 1 View Policies Current Attempt in Progress Pronghorn Inc. uses a calendar year for financial reporting. The company is authorized to issue 8,850,000 shares of $12 par common stock. At no time has Pronghorn issued any potentially dilutive securities. Listed below is a summary of Prongh...
1 answer
Aikman Corporation has the following cost records for June 2020: Indirect factory labour $4,550 Factory utilities...
Aikman Corporation has the following cost records for June 2020: Indirect factory labour $4,550 Factory utilities $400 Direct materials used 25,700 Depreciation, factory equipment 1,450 Work in process (6/1/20) 3,150 Direct labour 30,400 Work in process (6/30/20) 3,100 Mainten...
1 answer
Number 1, 3 am not sure if they are correct. Quiz 3 Nale. UUWIL ACCT 201...
Number 1, 3 am not sure if they are correct. Quiz 3 Nale. UUWIL ACCT 201 006 Each answer is worth 1 point. Please place the answers on this sheet. 1) A merchandiser: CA) Earns net income by buying and selling merchandise. B) Receives fees only in exchange for services. C) Earns profit from commis...
1 answer
Question 15 2 pts On January 1, 2016. Nolan, Inc. purchased 30% of the voting common...
Question 15 2 pts On January 1, 2016. Nolan, Inc. purchased 30% of the voting common stock of Bentley Corp. for $400,000. There was no amortization. During 2016, Bentley paid dividends of $15.000 and reported a net loss of $60.000 What is the balance in the Equity Investment account on December 31, ...
1 answer
1. The plot below summarizes the distributions of speeds of two groups of ships. The box...
1. The plot below summarizes the distributions of speeds of two groups of ships. The box plot on the extreme right is for all the ships. The other two box plots are for the individual groups For parts a through c, consider the box plot for Group 1. Based on this box plot alone, what can you conclud...
1 answer
Both A and B, explained please! Considering the requirement of an anti-periplanar geometry, what E2 product(s)...
Both A and B, explained please! Considering the requirement of an anti-periplanar geometry, what E2 product(s) is/are formed from each starting material? Note: Deuterium (Atomic Symbol: D) is one of the two stable isotopes of hydrogen. It nucleus contains one proton and one neutron, whereas the n...
1 answer
Question 6: An industrial engineer made a modification to a chip manufacturing process that will save...
Question 6: An industrial engineer made a modification to a chip manufacturing process that will save her company $10,000 per year. At an interest rate of 8% per year, how much will the savings amount to in 7 years? glish (US) MacBook Pro...
1 answer
#1, 2, 3, 4 Problem 1 The linear transformation T : x + Cx for a...
#1, 2, 3, 4 Problem 1 The linear transformation T : x + Cx for a vector x € R2 is the composition of a rotation and a scaling if C is given as C-[ 0. 0 0.5 -0.5 0 [1] (1) Find the angle o of the rotation, where - <s, and the scale factor r. (2) If x= without computing Cx, sketch x and the...
2 answers
Rosita earns money by walking dogs after school and on weekends
Rosita earns money by walking dogs after school and on weekends. She walks madeline evry other day. Buddy every fourth day, and Ernie every fifth day. Today she walked all three dogs.How many days will it be before Rosita walks Madeline and Buddy on the same day....
1 answer
(a) Find curl F curl F (b) What does your answer to part (a) tell you...
(a) Find curl F curl F (b) What does your answer to part (a) tell you aboFwhere C is the circle (a 5)2(5) in the ry-plane, oriented clockwise? e) It C is any closed curve, what can you say about Jc F.r (d) Now let C be the half circle (5)2 5)2 in the zy-plane with y 5, traversed from (6,5) to (4,5)....
1 answer
A linearly polarized beam of light of intensityI0 is propagating in the +z directionand...
A linearly polarized beam of light of intensityI0 is propagating in the +z direction and its direction of polarization makes an angle of 64° with the x-axis (the angle between the initial direction of polarization and the transmission axis of the first polarizer is 26° as described below). T...
1 answer
ANSWER IS EITHER A OR B ANSWER IS EITHER B OR D Consider the accompanying data...
ANSWER IS EITHER A OR B ANSWER IS EITHER B OR D Consider the accompanying data on breaking load (kg/25 mm width) for various fabrics in both an unabraded condition and an abraded condition. Use the paired t test to test Ho: HD0 sus H: HD > 0 at significance level 0.01. (Use Fabric 1 36.3 28.5 2 5...
1 answer
Concentration of NaOH Solution = 0.397 _M (from last week) 23 Trial # 1 Volume HCI...
Concentration of NaOH Solution = 0.397 _M (from last week) 23 Trial # 1 Volume HCI (mL) 10ml 1 ml 10mL 10mL 25.3 m2 19 mL Initial volume NaOH (mL) Final volume NaOH (mL) 25.3.149.3591/42.65mL Volume used NaOH (mL) 124.2m2 24.05mL | 23,65mL The following are the best three titration trials of NaOH th...
1 answer
An arrow is shot horizontally with a speed of 25 m/s from the top of a...
An arrow is shot horizontally with a speed of 25 m/s from the top of a 70 m building. How much time does it take to reach the ground? Please show all work, I am so confused. Thanks in advance . Will rate immediately !!...
1 answer
An insurance company insures a person's antique coin collection worth $20,000 for an annual premium of...
An insurance company insures a person's antique coin collection worth $20,000 for an annual premium of $300. If the company figures that the probability of the collection being stolen is 0.002, what will be the company's expected profit? PLEASE CREATE CHART...
1 answer
Can you please answer all three questions. Thank you so much!! QUESTION 3: What is the...
can you please answer all three questions. Thank you so much!! QUESTION 3: What is the purpose of the Tris-Acetate-EDTA (TAE) buffer that the agarose gel is prepared with and submerged in for running? What would happen if you used water to prepare and run the gel instead of TAE buffer? (You sho...
1 answer
A hot-air balloonist, rising vertically with a constant speed of 5.00 m/s , releases a sandbag...
A hot-air balloonist, rising vertically with a constant speed of 5.00 m/s , releases a sandbag at the instant the balloon is 40.0 m above the ground. (See (Figure 1)) After it is released, the sandbag encounters no appreciable air drag. **only need help with parts E-J Part A Compute the positi...