creating a basic spreadsheet

[logistic_guy]

The exercise is based on the following situation: Some electric utilities offer their customers a “time-of-use” rate plan, where the rate charged for electricity varies depending on the time of day. Often, a higher rate is charged for electricity used during peak hours of the business day, when demand is high and power plants are struggling to produce enough, while a lower rate is charged for off-peak use, when demand is lower than the power plants’ capacity. Suppose that the Jamesboro Valley Municipal Electric Company offers such a plan to its business customers. Monday through Friday, the peak rate is \(\displaystyle \$ 0.1385\) per kilowatt hour \(\displaystyle (\text{kWh})\) and the off-peak rate is \(\displaystyle \$ 0.0545\) per \(\displaystyle \text{kWh}\). On the weekend, the rate is \(\displaystyle \$ 0.0825\) regardless of time of day. (It is not unusual to have a rate go beyond two decimal places, though the overall bill would be rounded to the usual two.)

Create a spreadsheet to match the one shown below.

AnyCorp Manufacturing Inc. 7/06 Electric Bill​

​	Time of Use​	kWh used​	Rate per kWh​	Total​
1​	Weekday Peak​	28595​	0.1385​	$3,960.41​
2​	Weekday Off-Peak​	14675​	0.0545​	$799.79​
3​	Weekend​	8503​	0.0825​	$701.50​
4​	Totals​	51773​	N/A​	$5,461.70​

 

[khansaheb]

The exercise is based on the following situation: Some electric utilities offer their customers a “time-of-use” rate plan, where the rate charged for electricity varies depending on the time of day. Often, a higher rate is charged for electricity used during peak hours of the business day, when demand is high and power plants are struggling to produce enough, while a lower rate is charged for off-peak use, when demand is lower than the power plants’ capacity. Suppose that the Jamesboro Valley Municipal Electric Company offers such a plan to its business customers. Monday through Friday, the peak rate is \(\displaystyle \$ 0.1385\) per kilowatt hour \(\displaystyle (\text{kWh})\) and the off-peak rate is \(\displaystyle \$ 0.0545\) per \(\displaystyle \text{kWh}\). On the weekend, the rate is \(\displaystyle \$ 0.0825\) regardless of time of day. (It is not unusual to have a rate go beyond two decimal places, though the overall bill would be rounded to the usual two.)

Create a spreadsheet to match the one shown below.

AnyCorp Manufacturing Inc. 7/06 Electric Bill​

​	Time of Use​	kWh used​	Rate per kWh​	Total​
1​	Weekday Peak​	28595​	0.1385​	$3,960.41​
2​	Weekday Off-Peak​	14675​	0.0545​	$799.79​
3​	Weekend​	8503​	0.0825​	$701.50​
4​	Totals​	51773​	N/A​	$5,461.70​

Please show us what you have tried and exactly where you are stuck.

Please follow the rules of posting in this forum, as enunciated at:

READ BEFORE POSTING​

Please share your work/thoughts about this problem