JordanBudget - 240,000 248,000 256,000 General and Sales...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ACCT 245 EXCEL BUDGET EXERCISE Give the data below, construct a static and a flexible budget for Johnson Relay Company, at different volumes. Assume that Johnson Company's Static Budget was to make and sell 30,000 relays. Please use cell addresses and formulas and underline appropriately. Static Budget Flexible Budget Number of units 28,000 29,000 30,000 31,000 32,000 Per Unit Sales Revenue $53 1,590,000 1,484,000 1,537,000 1,590,000 1,643,000 1,696,000 Variable Costs Direct Materials $12 360,000 336,000 348,000 360,000 372,000 384,000 Direct Labor $6 180,000 168,000 174,000 180,000 186,000 192,000 Manufacturing O/H $8 240,000 224,000 232,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 240,000 248,000 256,000 General and Sales O/H $10 300,000 280,000 290,000 300,000 310,000 320,000 Total Variable Costs 1,080,000 1,008,000 1,044,000 1,080,000 1,116,000 1,152,000 Contribution Margin 510,000 476,000 493,000 510,000 527,000 544,000 Less Fixed Costs Manufacturing O/H 370,000 370,000 370,000 370,000 370,000 370,000 370,000 General and Sales O/H 110,000 110,000 110,000 110,000 110,000 110,000 110,000 Total Fixed Costs 480,000 480,000 480,000 480,000 480,000 480,000 Net Income 30,000 (4,000) 13,000 30,000 47,000 64,000 Rename as yourlastnameBudget.xls...
View Full Document

This note was uploaded on 04/08/2008 for the course ACCT. 245 taught by Professor Kotes during the Spring '08 term at Western Washington.

Ask a homework question - tutors are online