We are starting a brand$-$new business called Jingle Beers, a Christmas ornament company, on January $1,2023.$ The company takes empty beer cans and makes them into lighted decorations, which it will sell for $$19\mathrm{.}99.$ Empty beer cans are obtained from a local recycler, and the lights are ordered from Amazon. The following costs are known items needed quoted by suppliers:

Empty Beer Cans, pallet of $700,$ $$112$

Fairy Light strands, case of $25,$$$162\mathrm{.}50$

Branded packaging, $60$ boxes for $$65$

Rent $$\frac{650}{?}$ month

Insurance, $$\frac{100}{?}$ month

Variable Overhead, $$1\mathrm{.}20$ per Jingle Beer

The company has hired the following employees:

Punchers $(2)-$ $$11/$hour

Light installers $(2)$ $$10/$hour

Packager $(1)-$ $$\frac{10\mathrm{.}25}{?}$ hour

Manager $-$ salary of $$50,\frac{000}{?}$ year

In order to make one jingle beer, the following time is necessary:

Punchers can punch out $5$ cans per hour $=5000$ hours

Light installers can light $10$ cans per hour $=2500$ hour

Packagers can package $10$ cans per hour $=2500$ hours

Based on the company's operations, it has chosen to apply overhead based on direct materials. For the upcoming year, the company hopes to sell $25,000$ Jingle Beers. It's worst$-$case scenario would be selling $20,000$ Jingle Beers, and its maximum sales projection is $36,000$ Jingle Beers. The company hopes to produce $35,000$ Jingle Beers this year, in order to have adequate leftover inventory for the next seas$$n$.$ The company has chosen to use the absorption costing method.

Required:

Prepare a budgeted schedule of costs and determine a cost per Jingle Beer using the absorption costing method. $$ DM$,$ BC$,$ Variable, fixed

Prepare a flexible budget for the $3$ sales levels indicated. Be sure to include projected contribution margin and projected income.