THIS IS ALL IN AN EXCEL BUT I CAN'T PASTE IT. PLEASE SHOW ME HOW YOU GOT THE ANSWER SO I CAN TRANSLATE AND PUT THE FORMULA IN EXCEL TO FIND THE ANSWER AND PLUG IT IN :) (WHAT I'LL BE DOING EX: =(G17+H20))I REALLY HOPE YOU CAN HELP ME :) THANKS!

OPTIMA, INC.

General information:

Selling price of bamboo rocking horses $33.50 Linear feet of bamboo required per rocking horse 3

Cost of bamboo per foot $2.00 Hours required to build $0.50 Average hourly direct labor rate $15.00

Additional information:

Ending finished goods inventory (percentage of the next quarter's sales) 40%

Ending raw materials inventory (percentage of the next quarter's production) 30%

Quarters/Year

Variable manufacturing overhead rate per direct labor hour $8.00

Estimated quarterly fixed manufacturing overhead $275,000.00 4

Estimated monthly selling and administrative expenses:

Variable $6.00

Fixed $200,000.00

Expected number of frames sold in following quarters:

4th Quarter 2013 55,000

1st Quarter 2014 65,000

2nd Quarter 2014 70,000

3rd Quarter 2014 75,000

4th Quarter 2014 90,000

1st Quarter 2015 90,000

2nd Quarter 2015 75,000

Additional information:

Cash on hand at April 1 $250,000 Percentage of sales in cash 80% Percentage of credit sales collected during quarter of sale 50%

Percentage of credit sales collected in quarter following sale 50%

Percentage of direct material purchases paid in quarter purchased 80%

Percentage of direct material purchases paid in following quarter 20%

$75,000

$50,000 $750,000 $40,000 $1 $250,000

OPTIMA, INC.

Depreciation included in quarterly fixed manufacturing overhead $75,000 Depreciation included in quarterly fixed selling and administrative expenses $50,000

Amount expected to be paid for a piece of equipment (purchased in 4th Quarter) $750,000

Minimum cash balance required 40,000 Borrowing increments $1 Quarterly dividend payments $250,000

Regarding Inventory:

Work-in-process has a zero beginning and ending balance.

Raw Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Produced - Sold = Ending)

Raw Materials Inventory dollar amounts need to be rolled forward to get the ending balance: (Beginning + Purchased - Used = Ending)

OPTIMA COMPANY

SALES BUDGET

FOR THE YEAR ENDING DECEMBER 31, 2020

QTR.1 QTR 2 QTR 3 QTR 4 TOTAL

BUDGETED SALES (UNITS) ? ? ? ? ?

UNIT PRICE ? ? ? ? ?

TOTAL SALES ? ? ? ? ?

OPTIMA COMPANY

PRODUCTION BUDGET

FOR THE YEAR ENDING DECEMBER 31, 2020

BUDGETED SALES (UNITS) QTR1 QTR 2 QTR 3 QTR 4 TOTAL

DESIRED ENDING INVENTORY (UNITS) ? ? ? ? ?

LESS: BEGINNING INVENTORY (UNITS) ? ? ? ? ?

BUDGETED PRODUCTION (UNITS) ? ? ? ? ?

OPTIMA COMPANY

DIRECT MATERIALS PURCHASES BUDGET

FOR THE YEAR ENDING DECEMBER 31, 2020

QTR 1 QTR 2 QTR3 QTR 4 TOTAL

BUDGETED PRODUCTION UNITS ? ? ? ? ?

MATERIALS PER UNIT ? ? ? ? ?

PRODUCTION NEEDS

DESIRED ENDING INVENTORY

LESS: BEGINNING INVENTORY

PURCHASES

COST PER UNIT

PURCHASE COST