Samara Co. Manufactures chairs for use in patios & gardens. Because of the seasonality business of Samara managers prepare annual budget for the company. The company’s controller Ahmed Ali is particularly concerned with the cash flows. As hisplans must be made in order to provide for the company’s cash needs during the off season. Ahmad has been developing several models to assist him in forecasting various elements of the cash flow. The information presented below will be used to develop a model to predict the cash requirements for quarterly dividends on common stocks. • Company manufacturers the chairs only on order that is one month’s production is equivalent to the next month’s shipment. Therefore, detailed operating budgets were developed in terms of units to be produced. 450,000 chairs for next year. Sales price is $60 per chair. • Variable production costs Raw materials 11 per unit Direct labor 10 per unit Variable overhead 150% of direct labor in dollars • Fixed manufacturing overhead is projected to be $3,600,000for the year to be applied on the basis of units produced. • Fixed and administrative and selling costs are budgeted at $ 540,000 to be expended evenly throughout the year. Variable selling expenses are $1.50 per chair. • The company uses the straight -line method to depreciate its assets. At the beginning of the year the monthly amount budgeted for depreciation was $44,000. The company plans to by new equipment on May 1 ($60,000 useful life 5 years no salvage value) & in August 1 ($96,000 useful life 5 years no salvage value) The company’s policy is to depreciate assets in the month they are acquired. • The company has a license agreement with Dulux Inc. for the finish process that is patented by Dulux. Under the agreement the company pays Dulux $0.50 per unit produced. Those payments are paid at the end of the month. • The company has a long term note payable with its primary Bank (National Bank) that requires monthly payments of interest and a principle payment at 31 December each year.On January 1 of budget year the balance of the note was $1,200,000 the annual interest rate 9%. And the principle payment of $200,000. • The company has 500,000 shares issued and outstanding as at 1 January and does not want to issue shares. The company wants to pay a quarterly cash dividend equal to 30% of earnings available to common stock. • The company uses a calendar year Ahmad wants to develop a model that will help predict the cash requirement for the quarterly dividends The model should be stated in terms of units produced using the following notation: P= units produced in a month t= time production in a month January is P1 and so on ignore tax effects Required : I- Build the model to using the notation above for each of the following Items for use in the model to calculate the company’s earnings available for dividends at June 30 a) Revenue b) Variable manufacturing cost of sales c) Total selling and administrative expense d) Depreciation e) Licensing fees f) Interest expense II= Advise Ahmad what would change in your model if you start continuous production rather than on order production as the policy is now. III what would change in your model if the company issued preferred shares

Samara Co. Manufactures chairs for use in patios & gardens. Because of the seasonality business of Samara managers prepare annual budget for the company. The company’s controller Ahmed Ali is particularly concerned with the cash flows. As hisplans must be made in order to provide for the company’s cash needs during the off season. Ahmad has been developing several models to assist him in forecasting various elements of the cash flow. The information presented below will be used to develop a model to predict the cash requirements for quarterly dividends on common stocks. • Company manufacturers the chairs only on order that is one month’s production is equivalent to the next month’s shipment. Therefore, detailed operating budgets were developed in terms of units to be produced. 450,000 chairs for next year. Sales price is $60 per chair. • Variable production costs Raw materials 11 per unit Direct labor 10 per unit Variable overhead 150% of direct labor in dollars • Fixed manufacturing overhead is projected to be $3,600,000for the year to be applied on the basis of units produced. • Fixed and administrative and selling costs are budgeted at $ 540,000 to be expended evenly throughout the year. Variable selling expenses are $1.50 per chair. • The company uses the straight -line method to depreciate its assets. At the beginning of the year the monthly amount budgeted for depreciation was $44,000. The company plans to by new equipment on May 1 ($60,000 useful life 5 years no salvage value) & in August 1 ($96,000 useful life 5 years no salvage value) The company’s policy is to depreciate assets in the month they are acquired. • The company has a license agreement with Dulux Inc. for the finish process that is patented by Dulux. Under the agreement the company pays Dulux $0.50 per unit produced. Those payments are paid at the end of the month. • The company has a long term note payable with its primary Bank (National Bank) that requires monthly payments of interest and a principle payment at 31 December each year.On January 1 of budget year the balance of the note was $1,200,000 the annual interest rate 9%. And the principle payment of $200,000. • The company has 500,000 shares issued and outstanding as at 1 January and does not want to issue shares. The company wants to pay a quarterly cash dividend equal to 30% of earnings available to common stock. • The company uses a calendar year Ahmad wants to develop a model that will help predict the cash requirement for the quarterly dividends The model should be stated in terms of units produced using the following notation: P= units produced in a month t= time production in a month January is P1 and so on ignore tax effects Required : I- Build the model to using the notation above for each of the following Items for use in the model to calculate the company’s earnings available for dividends at June 30 a) Revenue b) Variable manufacturing cost of sales c) Total selling and administrative expense d) Depreciation e) Licensing fees f) Interest expense II= Advise Ahmad what would change in your model if you start continuous production rather than on order production as the policy is now. III what would change in your model if the company issued preferred shares

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Concept explainers

Question

• Company manufacturers the chairs only on order that is one month’s production is equivalent to the next month’s shipment. Therefore, detailed operating budgets were developed in terms of units to be produced. 450,000 chairs for next year.

Sales price is $60 per chair.

•

Variable production costs
Raw materials	11 per unit
Direct labor	10 per unit
Variable overhead	150% of direct labor in dollars

• Fixed manufacturing overhead is projected to be $3,600,000for the year to be applied on the basis of units produced.

• Fixed and administrative and selling costs are budgeted at $ 540,000 to be expended evenly throughout the year. Variable selling expenses are $1.50 per chair.

• The company uses the straight -line method to depreciate its assets. At the beginning of the year the monthly amount budgeted for depreciation was $44,000. The company plans to by new equipment on May 1 ($60,000 useful life 5 years no salvage value) & in August 1 ($96,000 useful life 5 years no salvage value)

The company’s policy is to depreciate assets in the month they are acquired.

• The company has a license agreement with Dulux Inc. for the finish process that is patented by Dulux. Under the agreement the company pays Dulux $0.50 per unit produced. Those payments are paid at the end of the month.

• The company has a long term note payable with its primary Bank (National Bank) that requires monthly payments of interest and a principle payment at 31 December each year.On January 1 of budget year the balance of the note was $1,200,000 the annual interest rate 9%. And the principle payment of $200,000.

• The company has 500,000 shares issued and outstanding as at 1 January and does not want to issue shares. The company wants to pay a quarterly cash dividend equal to 30% of earnings available to common stock.

• The company uses a calendar year

Ahmad wants to develop a model that will help predict the cash requirement for the quarterly dividends

The model should be stated in terms of units produced using the following notation:

P= units produced in a month

t= time

production in a month January is P1 and so on

ignore tax effects

Required :

I- Build the model to using the notation above for each of the following Items for use in the model to calculate the company’s earnings available for dividends at June 30

a) Revenue

b) Variable manufacturing cost of sales

c) Total selling and administrative expense

d) Depreciation

e) Licensing fees

f) Interest expense

II= Advise Ahmad what would change in your model if you start continuous production rather than on order production as the policy is now.

III what would change in your model if the company issued preferred shares

Expert Solution

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.