How would I create a simple budget based on the following?

You are in charge of putting together a budget for The Wooden Trunk, a business that is going to manufacture and sell necklaces for the benefit of the The Little Lighthouse, Tulsa, OK. This includes compiling a budgeted income statement. Be creative, but keep your budgets on ONE page.

Your budget must include:

One sales number, which is made up of how much YOU think each necklace should be sold for ($40) and how many necklaces you think the company can sell in two weeks (30).

COGS budget. I will give that to you. COGS per necklace is $10.00. You do not need to create an inventory roll forward. Just use $10.00 per necklace sold.

Wage budget. The employee making the necklaces charges $20.00 per necklace.

Other costs. Just call this overhead instead of breaking out all the expenses. Overhead is a flat amount of $100.00. Not per necklace. Just $100 for the two-week span of time.

Wooden trunk Budgeted Income Statement Unit Statement Necklace to be sold in the-30 per 2 weeks 26-] nos ear 780 Budget Details Calculation Amt $ 31,200 Sales revenue @$40 per 40 780 pc Less Cost Of Necklaces Materials $10 per pc 10*780- Wages @S20 per pc Overheads@$100 per26100 7,800 15,600 2,600 20 780- 26*100- 2weeks Total Cost of Necklaces 26,000 Net Operating Income 5,200