A bakery sells its pies for $6.00 each.The bakery incurs a daily fixed cost of $500 which includes salaries and rental.The variable cost per pie is $2.50.Set up this problem in Excel as shown below to compute the number of pies (X)that must be baked daily in order to break even.Model the problem mathematically without using Goal Seek.

Question

A bakery sells its pies for $6.00 each.The bakery incurs a daily fixed cost of $500 which includes salaries and rental.The variable cost per pie is $2.50.Set up this problem in Excel as shown below to compute the number of pies (X)that must be baked daily in order to break even.Model the problem mathematically without using Goal Seek.
A bakery sells its pies for $6.00 each.The bakery incurs a daily fixed cost of $500 which includes salaries and rental.The variable cost per pie is $2.50.Set up this problem in Excel as shown below to compute the number of pies (X)that must be baked daily in order to break even.Model the problem mathematically without using Goal Seek.

Quizplus · Accepted Answer

The Answer of A bakery sells its pies for $6.00 each.The bakery incurs a daily fixed cost of $500 which includes salaries and rental.The variable cost per pie is $2.50.Set up this problem in Excel as shown below to compute the number of pies (X)that must be baked daily in order to break even.Model the problem mathematically without using Goal Seek.

A Bakery Sells Its Pies for $6