Weekly to Daily Conversion If Function

Hi all,

I've attached a workbook that highlights my problem. We have a file that lists out a weekly requirement of widgets to be produced. Sheet 1 represents this file. Basically it says that during the week ending 5/22 we need to make 5 widgets each day and so on.

I need to convert that so that I can show a daily requirement. If I just do a hlookup, I get a bunch of #N/A since the original file is weekly. This is represented in sheet 2.

I need a formula that will show the weekly requirement for each day. Sheet 3 shows how I need it to look.

can anyone help me out?

Thank you