Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Furniture, Inc makes and sells a single product called a Bik The company wants to prepare the direct material budget for the quarter ending June 30 Balgeted production of Biks for the next six months in as follows: February 14

Furniture, Inc makes and sells a single product called a Bik The company wants to prepare the direct material budget for the quarter ending June 30 Balgeted production of Biks for the next six months in as follows: February 14

Accounting

Furniture, Inc makes and sells a single product called a Bik The company wants to prepare the direct material budget for the quarter ending June 30 Balgeted production of Biks for the next six months in as follows: February 14.000 Units March 15,300 Uniti April 11.900 Units May 12.600 Units June 14.500 Units July 16,000 Unte It takes three yards of Material A to make one B The company wants to maintain monthly ending story of Material Aqual to 20% of the following month's production seeds On March 31, 2.000 yards of Material A were on hand The cost of Material A 1 55 per yard Required: 1. Prepare the Direct Materials Budget for April May June, and quarter 2. Based on the dwect material budget that you ved in requirement above and sume that the direct matenals puchate in February was S150,000 and in March was 5160,000 Prepare the cash disbursements budget for April of the company policy for paying purchases is as follows 10% in the month of purchase SONO month after purchase two miths after purchaser
Raran Complifiy has the following information during the month of June 2020 Cash Balance, May 31 $22.500 Dividends paid in June 6.000 Cash paid for operating expenses in June 18.400 Equipment depreciation expense in June 2,250 Patent torturation expense in June 1.000 Cash collections on sales in June 56.250 Merchandise purchases paid in June 43,109 Purchase equament for cash in June 8,750 Sales commission (50% paid in June) 15.250 Razan Company wants to keep a minimum cash balance of $3.000 Asume that borrowing occurs at the being of the month and repayment occul the end of the mouth Monthly interest of 1% paid in cash at the md of each month when debt is outstanding Borrome and repayments are carried out in miltiples of $1.000 Required: Prepare a cash budget for Fun
Blackboard - 2 x ??? Remaining Time: 1 hour, 53 minutes. 24 seconds. • Question Completion Status: 2 . 10 91 12 14 15 Question 10 . points SA Morda considering starting a small catering business He would need to purchase a delivery and various equat cost $125.000 o equip the business and another $60.000 for working capital needs Rent for the building used by the business will be $35,000 per year. In addition to the building central cash outlow for operating costs will amount to $10,000 Murad's marketing studies indicate that the annual cash flow from the bus will amount to $120.000. All of working capital would be released at the end of 6 years Murad wants to operate the catering business for only six years. He estimates that the equipment could be sold at that time for 4% of its original cost Murad sa 16% du count rate Use the following present value tables, to determine the appropriate discount factor Present Value of $1. 1(1+) Periods 89 9% 10% 11% 12% 13% 14% 15% 16% 17% 0.73567080.683 06590636 0.6130592037203520:53 Present Value of an Anouits of St in Arrears 11-1 (1-1) 0.6810650 0.621 0.39305670154303190,49704760456 6 0.6300596 0.56 0.535 0.5070.4800456 0.4320 4100-390 0.583054205130452 0.452 0.125 0.400 0.3760.854 0.333 Periods 84 994 10% 115 129 1396 1495 1996 16% 1796 + 3312 12402170 2.102 3.037297429142.855 279821743 3991901913606 605 3:51132523.274 2199 0 6.6222642542313998388968 3.589 52066436 4423 42854.160 4639 3.92 Required Compute the represential of this restant

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Ans: First of all I am sorry , The sum has a lot of sub parts , and I can answer only 4 as per Chegg Guidelines. I will try my best

PLEASE GV A RATING IF U LIKE MY EFFORTS, IT WILL KEEP US MOTIVATED. THANK YOU IN ADVANCE.

In case u need further clarification, use Comment box. Thank U

Ans :   

Direct Materials Budget

       

Particulars

April

May

June

Total Qtr

a)Budgeted production units

11900

12600

14500

39000

b)Material needed per unit (pound)

3

3

3

3

c) Total material requirement to meet production (a*b)

35700

37800

43500

117000

d)Add: Closing Inventory Desired (% of next month)

7560

8700

9600

25860

e)Total needs (c+d)

43,260

46,500

53,100

142860

f)Less: Opening inventory

2000

7560

8700

18260

g)Budgeted purchase units (In Yards) ( e-f)

41260

38,940

44,400

124600

h) Cost per pound($)

5

5

5

5

I) TOTAL VALUE of PURCHASE (g*h)

180600

194700

222000

597300

Schedule of Payment to Creditors by month and in total

Particulars

     

April

May

June

Total

Prev to prev month (40%)

     

60000(150000*0.4)

88680

72240

220920

Prev month (50%)

     

80000(160000*0.5)

90300

97350

267650

Same month Purchase (10%)

     

18060(180600*0.10)

19470

22200

59730

Total cash payments

     

214710

198450

191790

548300

Cash Budget for June

Particulars

Details

Amount

A)Opening cash balance

 

22500

     

B) Collection during the month

   

Sales collection

 

56250

     

C)Payments during the month

   

Div paid

 

6000

Operating exp

 

18400

Purchases

 

43100

Equipment

 

8750

Sales commission

15250*50%

7625

Total (C)

 

83875

     

D) Net Balance (A+B-C)

 

(5125)

E)Loan taken

5125+5000=10125

11000(Since multiple of 1000)

F)Interest Paid

11000*1%

110

G)Closing balance

Minimum balance

5765

     

 

CELL NOS

 

0

1

2

3

4

5

6

A)

SALES

 

120000

120000

120000

120000

120000

120000

B)

Rent

 

35000

35000

35000

35000

35000

35000

C)

Operating cost

 

40000

40000

40000

40000

40000

40000

D)

DEP (SLM)

 

20833

20833

20833

20833

20833

20833

E)A-B-C-D

EBIT/PBT

 

24167

24167

24167

24167

24167

24167

F)

Less:Taxes(NA)

 

0

0

0

0

0

0

G) E-F

Unlevered net income

 

24167

24167

24167

24167

24167

24167

H)

Add:CCA/DEP

 

20833

20833

20833

20833

20833

20833

I)

Less:WC

-60000

           

J)

Less: Cap EXP

-1,25,000

         

5000 (125000*4%)

K)

Add: wc Recovered

           

60000

L) G+H-I+K

Free Cash flow

-1,85,000

45000.00

45000.00

45000.00

45000.00

45000.00

110000.00

M)

DF @16%

1

0.8621

0.7432

0.6407

0.5523

0.4761

0.4104

N)L*M

PV

-185000

38793.10

33442.33

28829.60

24853.10

21425.09

45148.65

NPV

7491.86

Related Questions